Solved

Incorporate Index

Posted on 2015-01-03
19
139 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:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 8
19 Comments
 
LVL 30

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:Naresh Patel
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 30

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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 8

Author Comment

by:Naresh Patel
ID: 40529173
Yes Sir.
0
 
LVL 30

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:Naresh Patel
ID: 40529237
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40529239
out of the box - Sir do you trade in Stock market?
0
 
LVL 30

Expert Comment

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

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
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40529321
Yes
0
 
LVL 8

Author Comment

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

Thanks
0
 
LVL 30

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 30

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:Naresh Patel
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:Naresh Patel
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 30

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:Naresh Patel
ID: 40530052
Awesome
0
 
LVL 8

Author Comment

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

Author Comment

by:Naresh Patel
ID: 40530062
here it is BSE Eq.

Thanks
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

726 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