Retrieve tables from web with variable URL

H

hermac

Hello,
This URL
http://www.bibf.be/ipc/tamenu.asp has a field "postcode", asking for
a 4-digit entry and leading to the links of all members of that postal
code when all other inputs are omitted.
The visible URL in the URL bar , however , remains unchanged.
I have a list in Excel with several postal codes e.g. 2200 2500
2222 3000 for which I want to retrieve the members tot list them up
on a worksheet. I know enough VBA to do that if I only knew the key
to build that postal code into the URL. Is there a way to do that?
Thank you very much for any help.
Herman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top