+ Reply to Thread
Results 1 to 6 of 6

Excel VBA UK Addresses from PostCode or Longitude/Latitude

  1. #1
    Registered User
    Join Date
    02-19-2010
    Location
    Stafford
    MS-Off Ver
    Excel 2003
    Posts
    20

    Excel VBA UK Addresses from PostCode or Longitude/Latitude

    All,

    Massive help in the past, but here's a big one.

    I have a list of post codes, which I want to convert to addresses.
    I can convert post code to longitude/latitude, so either looking for a one step UK Post Code to Address or a UK Post Code to Lon/Lat to Address.

    Anyone had any joy with this? your help as always would be great.

    Niper

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Excel VBA UK Addresses from PostCode or Longitude/Latitude

    ......Wut?

  3. #3
    Registered User
    Join Date
    02-19-2010
    Location
    Stafford
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Excel VBA UK Addresses from PostCode or Longitude/Latitude

    sorry, not sure I explained myself very well.

    I have a UK post code, say my post code ST18 9EU, which I can convert to long/lat of -2.1962761, 52.78083737.

    But I need to convert to an address of Ash Drive, Haughton, Stafford. UK

    This website will convert it (http://www.findlatitudeandlongitude....p#.UNFwbndsJ8E), but I need to know if this is possible using Excel VBA with maybe Google Maps API, Geocode, or another mapping API.

    Thanks

    Paul

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Excel VBA UK Addresses from PostCode or Longitude/Latitude

    Yes, the process is called reverse geocoding.

    There are loads of paid for services out there - have a look at "Postcode Anywhere" we use them for GeoCoding and their data seems the most accurate.

    If you want to do this for free, it's possible but you have to carefully read the terms and conditions of the services you use, for example it's easiest with the google API, but it violates their terms and conditions by not displaying the data on a map - you'd just be returning the data to Excel.

    I believe the Bing Maps API does not have such a stipulation, but you will need to jump through a couple of hoops, first off you'll need a developer key, you can then use the below as a standard worksheet function:

    Please Login or Register  to view this content.
    Where:
    A1 contains Lattitude
    B1 contains Long

    PHP Code: 
    =ReverseGeo(A1,B1
    On the plus side, it appears to be faster than the google service, you might need to watch out for maximum request limits though - I'm not sure what they are.

  5. #5
    Registered User
    Join Date
    02-19-2010
    Location
    Stafford
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Excel VBA UK Addresses from PostCode or Longitude/Latitude

    Excellent...thanks, I'll try and register with bing maps to get a developer key then give it a try.

    Much apprecited. Ill let you know how I get on.

    Niper

  6. #6
    Registered User
    Join Date
    02-19-2010
    Location
    Stafford
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Excel VBA UK Addresses from PostCode or Longitude/Latitude

    Excellent...thanks, I'll try and register with bing maps to get a developer key then give it a try.

    Much apprecited. Ill let you know how I get on.

    Niper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1