Solved

Incorporate Index

Posted on 2015-01-03
19
137 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
[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 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Outlook Free & Paid Tools
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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.

733 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