Thread: Can Excel VBA search for and read URL
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dirk Nachbar Dirk Nachbar is offline
external usenet poster
  
Posts: 11
Default 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

Reply With QuoteReply With Quote