View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pete pete is offline
external usenet poster
 
Posts: 88
Default Looping Web Query

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