Thread
:
Looping Web Query
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Looping Web Query
More info along with your macro and urls for comments
--
Don Guillett
SalesAid Software
"Pete" wrote in message
...
This one might not be possible, but I thought I would try.
I want to analize some data in excel that is taken off
the web but first I need to inport the data into one
master database. My problem is that I need to inport
roughtly 55-60 different pieces or files of info and each
piece of info is linked to another web
address "Hyperlinded". I have the Web address (located in
cell A1) I need to go to start with and also a list of
names (located in Cells A2:A60) that I need to click on
to get the appropriate info.
How can I tell the web query to goto this particular wed
site find the first name in cell A2 open that new address
and inport a particular chart in the first avalilbe cell
in coloum C?
I have tried recording this and inserting loop statment
to keep going but it just doesn't work for me.
Any help or guidance is appreciated.
Best regards,
Pete
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]