Website Query Help

Is it possible to change the URL of website queries without excel forgetting which tables that you selected? I have a few pages that I would like to query, and then change the url a bit, but get the same data off the new URL, which is set up the exact same way as the first page.

You'd need to have a webquery and concatenate it.

Look here

http://www.mrexcel.com/forum/showthread.php?t=11732