Web Query Macro Change, New Page per Query

Hi All, I have obtained the following code from a previous post. This Macro works perfectly, but I would like it modified so that each webquery/import goes into a new worksheet a.o.p to all the data going into 1 worksheet.
There is a comment within the code ' Add new worksheet to store data and try to rename. Don't understand this cause no new sheets are added.


Thanking you in advance

Floyd

Please Login or Register  to view this content.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


If you do a Google search for "change macro" you get: "About 140,000,000 results (0.19 seconds)"

Try something like this:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

As for your error handling, it's usually not advisable to tell Excel to forget about all errors as if they have never happened. It's better to learn how to debug, trap errors and handle them accordingly.

Hope this helps.

abousetta

Yes, I forgot to set the variable. I changed my post above. It should work now.

Try this modified version:

Please Login or Register  to view this content.

abousetta

Glad I was able to be of assistance.

Good luck.

abousetta