Solved

Incorporate Index

Posted on 2015-01-03
19
115 Views
Last Modified: 2015-01-04
Hi Experts,

I have Two WB with 2 set of VBA codes. need to incorporate both in ONE.

See attached files.

Thanks
Incoporated-Download-File.xlsm
NSE-Index-Importer-V01.xlsm
0
Comment
Question by:itjockey
  • 11
  • 8
19 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40529098
Just before venturing again how many of these htpp you have ???? as for sure we should use a different approach !!
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529111
Total 6 out of 3 codes I have ready....which I am grouping .other 3 have to first code ready and then grouping. If you have any different approach then I pls let me know.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529171
Absolutely a different approach !!!!

If I am not mistaken all that is different bewtween each version are 3 things:
1) the directory to where the version is saved
2) the http address
3) the column of EQ ...

Correct ?
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529173
Yes Sir.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529204
ok then do the following
fill this file with the data and return it.

I noticed in Equity the file to read is different it is zip file if you can specify these details somewhow in the file would be great.
gowflow
Settings.xlsx
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529237
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529239
out of the box - Sir do you trade in Stock market?
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529305
Nope why ?
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529312
ok so do I have to understand that Index is the last part that is same as the others except that it does not have deleterows ??? and future is a totally different ball game ?

If yes then I have no problem changing the concept at least to adapt for the past 2 in the new format and then we can consider this question for that and then will take it from there on. Like you will see the new format in this question that should cater for all six possibilities whereas only 2 would work now equ and del.

Is that ok ?
gowflow
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 8

Author Comment

by:itjockey
ID: 40529321
Yes
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529449
All other three Question Ready to post after this get solved.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529625
ok now you have the buttons in Col A and you put the date in Col E and check the results.
Try delivery and Equity.

Any comment pls advise now so we can arrange for the whole concept.
Rgds/gowflow
Incoporated-Download-File-V01.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40529628
pls in case it is fine pls post 1 question at a time not all 4 together !
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529887
Did you incorporate index process in above attached file in your post? i.e. NSE-Index-Importer.xlsm (Which I had attached in my very 1st post?


Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 40529888
Equity & Delivery Working Fine. if for Index importer you want me to ask new question then pls let me know.

Thanks
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 40530017
Her it is with also the Index incorporated.
pls test it and let me know.
gowflow
Incoporated-Download-File-V02.xlsm
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40530052
Awesome
0
 
LVL 8

Author Comment

by:itjockey
ID: 40530054
May I ask new question?
0
 
LVL 8

Author Comment

by:itjockey
ID: 40530062
here it is BSE Eq.

Thanks
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now