+ Reply to Thread
Results 1 to 3 of 3

Use Google Maps to return driving time and distance

  1. #1
    Registered User
    Join Date
    10-22-2010
    Location
    Greenwood, IN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Use Google Maps to return driving time and distance

    Hello... I'm looking for a way to have Excel look up and return the driving time and distance for two points using Google Maps. I've seen on this forum and others that it can be done. I'm pretty good with Excel. But, I'm terrible with code. The only solutions I have found while searching involve a lot of code. I'm sure that's probably the answer. But, I would appreciate if someone could spell it out for me or post a file that I could examine. I'm using Excel 2010. Thanks greatly!

    A1=Start Address
    A2=Destination Address

    B1=Driving Time
    B2=Distance

    I've seen it a few places... One was on this forum from a couple years ago:
    http://www.excelforum.com/excel-gene...ing-times.html

    Google Developer:
    http://code.google.com/p/spreadsheet-data-connector/

    And, I know an acquaintance who has done it. Though, he isn't sharing the knowledge. I'm trying to add to a program for the fire department that will aid in planning by showing the driving time and distance from each firehouse to a location. Currently, the spreadsheet I use will return the order of arrival. I have to manually go into Google and look up each station to each geozone centerpoint. This is a large department with 67 fire stations and 550 geozones. I'm hoping to automate the process, rather than do 36,850 separate searches in Google Maps.
    Last edited by davesexcel; 05-12-2012 at 10:16 AM. Reason: Reset

  2. #2
    Registered User
    Join Date
    10-22-2010
    Location
    Greenwood, IN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Use Google Maps to return driving time and distance

    I just learned how to use Alt-F11 to open the VBA screen. I'm still trying to decipher some of the previously written code to do what I need it to do.

  3. #3
    Registered User
    Join Date
    12-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2012 Mac
    Posts
    1

    Re: Use Google Maps to return driving time and distance

    Here is what I tried
    A1 = 66234
    A2 = 72712

    A4 = =getGoogDistanceTime(A1,A2,"time")

    I have tried the previously mentioned code and no matter what I do the function returns #Value! for A4.

+ 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