I am using Moneyextra.com to set up web queries for all UK
share prices by sectors.

I have the list off all the address's of the sectors in
Sheets 1 ie:
http://www.moneyextra.com/stocks/sectors/AEROSPACE.html,
http://www.moneyextra.com/stocks/sec...OLDMINING.html
and
http://www.moneyextra.com/stocks/sec...ERROUSMETALS.h
tml

Each of these pages has a table on it detailing all of the
Shares that fall in that Sector which I would like to set
up a web query to excel. Ideally I would like each sector
to be a seperate sheet.

Thanks so much and let me know if you need more info.


-----Original Message-----
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


.