Hello Excel-ers!
I am working on automating an excel file and running into a ton of small problems which I am not able to really figure how to fix it.
Basically I have a Macro running perfectly for 1 single web querry. So in Short what it does is.
Takes an ID from the user, Imports the data for that ID from the web page. dumps it on a NEW SHEET. Finally OUTPUT SHEET Pulls out the data I require and presents it in a nice table.
This Works perfectly and the data is refreshed and copied to OUTPUT SHEET at regular Intervals (say 15min).
Not what I am trying to do is, Create an array (variant of size 10).
The user will input an ID. The macro fetches the data from the web. Dumps it on the a new sheet. These sheets should be stored as eg.
RAWDATA(1), RAWDATA(2),......RAWDATA(10) .
And Ofc I will have corresponding output sheets as
OUTPUT(1),OUTPUT(2).......OUTPUT(10).
So I can use command buttons (add new data etc) and obtain all these 20 sheets.
The problem I am having is I want to write a loop for this command button. where I am having some issues as I am using a counter 'i' but there is not a proper sub function that I can increment it.
Also I want the RAWDATA to be updated at regular time intervals (say 10min) and at the same time add a new row in the OUTPUT sheet and copy the data I want.
Here what happens is if I have 10 OUTPUT sheets, only the last one updates i.e. OUTPUT(10). all the other 9 stop updating, even though it is in a For/while loop i=1:10.
I hope my problem a bit clear?
If someone can throw some light please let me know.
If someone can spare some time please msg me, I can PM you the excel file.
Hope to hear soon.
Thanks guys.
Cheers
Bookmarks