+ Reply to Thread
Results 1 to 3 of 3

Comparing postcodes

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Comparing postcodes

    Hi,

    I have a rather intricate problem I need solved and need advice on how to go about getting the best result.

    I want to be able to have 2 journeys (each with their own start and end postcodes) and compare the distances between both start points, both end points, and, if possible, the routes themselves. The result would be to flag the journey is they were within say 50 miles of each other at both the end point and either the start or on route. Now I could do this manually using Google maps but I want to be able to this on mass.

    Anyone with a suggested method?

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Comparing postcodes

    Personally, I would use a site such as http://www.doogal.co.uk/DrivingDistances.php use SendKeys to enter the postcodes and then scrape the answers returned. By the looks of it you can send a list of journeys in one go so that would work for your batch process.

  3. #3
    Registered User
    Join Date
    11-14-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Comparing postcodes

    pjwhitfield: That site looks great but unfortunately doesn't quite cover what I'm after. Thank you for your feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Comparing postcodes and booking dates to identify clashes
    By ScottishJacqui in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2014, 11:52 AM
  2. Getting postcodes from a website using VBA
    By jseages in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2014, 06:44 AM
  3. Distance to many UK postcodes
    By samcdavies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2014, 12:13 PM
  4. Formatting UK postcodes
    By Bobjonson in forum Excel General
    Replies: 1
    Last Post: 08-16-2010, 12:38 PM
  5. Postcodes
    By PH NEWS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2006, 05:15 AM

Tags for this Thread

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