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