ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Retrieve tables from web with variable URL (https://www.excelbanter.com/excel-programming/438722-retrieve-tables-web-variable-url.html)

hermac

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


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com