Hi,

I am trying to compile a database of restaurant inspection records that
are posted on the web.

The reports are generated through a search engine, but the results just
pull up static websites.

The URL Of the website results look typically like this:

http://www.region.waterloo.on.ca/web...gent&pid=03102

The number at the end of the URL changes for each record that is pulled
up. There are hundreds (maybe thousands) of records, each with their
own URL. I can't seem to identify the range of report numbers, they
seem to have no set order. However, even if if you type in a report
number that doesn't exist, it still brings up a webpage.

Is there any way for me to run a macro in Excel that will repeatedly
query the website, each time changing the 5-digit number at the end of
the URL.

The front page of the website is he
http://www.region.waterloo.on.ca/web...nAgent&valid=y

Thanks,
Tamsin