Give us a sample (4-5) of the url's involved. And, a bit more info of the
project would be helpful. You may be making this more difficult than it has
to be.


--
Don Guillett
SalesAid Software

"Jimbo2001" wrote in message
...
Hi Excel Genius's

I am not sure if this is possible with VBA but I'm sure
someone can point me in the right direction.

I have a list of 98 web address in sheet 1 column A

What i would like to do is add a new sheet for each web
address and then add a web query to pick up a table. The
table is allways in the same location on the web page but
I dont know how the web queries work (Name, loaction on
page, etc??)

Can anyone help me? If the web query bit cant be done is
it possible for someone to give me some code for adding
the sheets from the list in column A?

Thanks so much