View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HS[_4_] HS[_4_] is offline
external usenet poster
 
Posts: 2
Default Loading in the BODY section of HTML from a web page

Hi all,

I know you can use the Web Query feature to load in elements of a web page.

However I wan to do the following:

- Specify the parameter for a URL (e.g www.yada.com/page.asp?=<PARAMETER)
and have Excel get the body of the html from that page, for 100 different
pages (the parameter will just be a number), and have each body be loaded
into a different cell
- I'll then process that body to extract the essential info.

How can I do this for the 100-odd diff pages? I can do it fine just for one,
manually specifying the parameter with Web Query....

Thanks
Haroon