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
|