Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel VBA search for and read URL
I want Excel to import data from the website
http://neighbourhood.statistics.gov.uk/dissemination/ for given postcodes, unfortunately it only works if you physically type in the postcode on the web, as putting the postcode into the PHP style URL doesn't work. Is Excel able to do that? Basically I want something like this With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://neighbourhood.statistics.gov.uk/dissemination/ LeadKeyFigures.do?a=3&b=5939933&c=" & Cells(i, 17) & "&d=14&e=16&g=409939&i=1001x1003x1004&m=0&enc= 1" Dirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Search and read registry for particular external application | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |