taking information from web site.

[billyw]

hi...

we currently have an issue where a website that we made has information on
it that previously came from a database. the database has long since
disappeared, sadly.

is there any way to take out the information from web pages and transfer
this to an excel worksheet.

there are over 100 web pages that cantain this information. each page
contains information on a specific contact.

the info in source format looks like
<font color="#0000FF">Owner:</font> persons name<br>
<br>

etc...

is there any way to cycle through each page and striping out this info in to
excel..
help greatly appreciated

regards

 

[Mike Fogleman]

Yes there is using a web query. It sounds like each web page has just 1
persons name on it. I have a workbook that does something similar for
bringing 24 web pages into Excel on 24 different sheets. It would not be too
difficult to modify my code to loop thru web pages and place them on 1
worksheet. This is assuming that the web pages have some sort of predictable
naming sequence. Such as :
http://12.220.6.163/CMEx_Reports/101_custom.html,
http://12.220.6.163/CMEx_Reports/102_custom.html.

If you would be interested in what I have, email me, and I will send you the
workbook.
Mike Fogleman