Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Web Query with looping variables in the URL | Excel Programming | |||
looping every third row | Excel Programming |