Trying to copy URL into Excel using VBA (And failing miserably)

Hi all, my first time here (in the 'flesh' at least)

I am attempting to use postcodes to get the Longitude / Latitude and/or Easting / Northing Coordinates from Streetmap.co.uk

I have a Sheet with a tidy little button to set it all off from but cannot, for the life of me, get it to do anything after trawling the web for days....

I can get it to open the webpage and bring up the correct postcode search page but cannot get it to strip the url into my sheet!!

Please help

Phil

How important is data accuracy here? And what do you want to do with it? the process you are referring to is known as reverse Geo-Coding and all services are not created equal - some are much more accurate than others. Commercial services tend to be much better - we geocode to the property, whereas most services will only geocode to the centre of the postcode.

There are plenty of commercial services out there that make this very easy - we use PostCode anywhere when setting up new customer accounts and then fall back to the free OS database for bulk additions - they provide easting and northing, but it's relatively straightforward to convert these to lat/lon.

Also, which do you really need, Easting/Northing or Lat/Long?

What I'm really trying to do is find a way to get VBA to pick up the url of a page I have loaded and place it in an excel sheet that I'm running the button macro from.

I have a partial macro to get the information from the sheet and open the "streetmap.co.uk" to the correct postcode and I can see the information in the url but am unable(not quite up to speed) to get the url string back.

Any help would be greatly appreciated.