View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hermac hermac is offline
external usenet poster
 
Posts: 2
Default Retrieve tables from web with variable URL

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