+ Reply to Thread
Results 1 to 2 of 2

Find Driving Distance or Time between 2 Addresses and Place in Cell

  1. #1
    jjward101
    Guest

    Find Driving Distance or Time between 2 Addresses and Place in Cell

    Hi,

    I am creating an estimation tool that among other things, will need to list the driving distance or time between two addresses.
    My Spreadsheet (attached) has cells which contain concatenated data to show the complete addresses on one line, but I am not
    finding anything particularly useful when searching in this forum as far as how to accomplish this.

    I am basically looking, for example, a way to have the address in Cell A1 enter into google maps as the starting point, the address
    in cell A2 enter into google maps as the destination point, and have the result in miles and driving time return into cell A3.
    (These are not exact cell references. The addresses are on the [Control] Tab in the attached workbook.

    Has anyone been able to successfully do this?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,161

    Re: Find Driving Distance or Time between 2 Addresses and Place in Cell

    Do you have a Google API key? When I see this question, usually the hardest part is that the user does not have a Google API key, which Google requires when accessing maps.

    Here's a tutorial for a VBA UDF that can calculate distance between points. https://www.exceldemy.com/calculate-...h-google-maps/ If you have a Google API key, you should be able to substitute it in to the code and get something to work for you.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Driving Distance Matrix calculation
    By Brawnystaff in forum Office 365
    Replies: 6
    Last Post: 10-07-2021, 02:01 AM
  2. Find distance to distance of addresses in excel
    By pick44 in forum Excel General
    Replies: 5
    Last Post: 02-08-2019, 10:05 AM
  3. Driving distance using google API
    By AV114 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2018, 07:51 AM
  4. Use Google Maps to return driving time and distance
    By KevanC in forum Excel General
    Replies: 2
    Last Post: 12-22-2013, 11:16 PM
  5. Help With VBA code for getting driving distance.
    By anfdrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2013, 11:06 PM
  6. Query Google maps to return driving distance and time
    By mickisme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2012, 06:18 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