Then it seems you're back to having to automate IE to load each page.

Plenty of example in past posts.

Tim


"Lost Secretary" wrote in message
...
I tried that, but it keeps returning an error:

Unable to open
https://158.158.100.63/epass/action/...doe&ddSociety=.
Cannot download the information you requested.

"Tim Williams" wrote:


Try setting up a web query in Excel using this URL: does it retreive
the information you want?

If so, you should be able to loop through your list of names, changing
the URL each time (replacing the "name" parts with the relevant
strings) and refresh the query to get each perrson's info.

Tim