LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert hard coded query criteria to Parameter Query Melanie[_2_] Excel Discussion (Misc queries) 0 July 15th 08 09:59 PM
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM
Web Query with looping variables in the URL titus.hanke Excel Programming 6 July 5th 04 03:49 PM
looping every third row Jason Hancock Excel Programming 5 July 1st 04 08:00 PM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"