[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Incorporate Index

Posted on 2015-01-03
19
Medium Priority
?
158 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
  • 11
  • 8
19 Comments
 
LVL 31

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 31

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 8

Author Comment

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

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 31

Expert Comment

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

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 31

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 31

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 31

Accepted Solution

by:
gowflow earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 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