I have more than 500 queries (each from a different webpage) that I want to combine into one query. Seeing that most of the webpages only differ with numbers at the end. (the basic webpage address/1 changing to /2 /3 etc. giving me over 500 webpages eventually to do a basic webquery from)
The data is downloaded into 2 workbooks with a worksheet for each webquery numbered according to the last part of the address, (the basic webpage address/1 going to worksheet 1, /2 going to worksheet 2 etc.)
I spent 3 days recording a macro, but when I tried to run it I had an error message saying the macro was to big to run. I also need it to insert a column after every query or before every query seeing that I don't want the old data to be erased. Is it possible to run all these queries in one query and having the data from separate webpages go to separate worksheets in one click? Even a couple would be fine too, I just dont want to do it over 500 times seeing that I want to do the query up to 6 times a day eventually.
This is the first time I'm doing something like this and I have no idea what I'm doing so I would really appreciate it if you could explain how to do it (if possible) like you would to to a kid who has a new computer
Thank you in advance. I really appreciate it.
Microsoft Office