+ Reply to Thread
Results 1 to 4 of 4

Distance and mileage function to use with google maps in excel 2007

  1. #1
    Registered User
    Join Date
    06-29-2013
    Location
    earth
    MS-Off Ver
    Excel 2007
    Posts
    8

    Question Distance and mileage function to use with google maps in excel 2007

    Hi all,
    I am a newby to this forum and Excel databases but would like some information on using a function in excel 2007 to retrieve results from Google maps "Get Directions" and insert/update my excel 2007 database of UK Locations with the relevant "Mileage and Time" results.Book1.xlsx
    My excel database consists basically of 5 columns: (Example)Book1.xlsx
    A1: From, B1: Location, C1: County, D1: Area, E1: Type, F1: Mileage, G1: Time
    Note: Column A "From" would always be the same value (start point address)

    I would obviously like the results of Mileage and Time in the relevant cells (F1 and G1) per row, however my database consists of 16,000 records and therefore would be very time consuming by inserting manually.
    Is there such a code and can this be achieved?
    Many thanks in advance

  2. #2
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Distance and mileage function to use with google maps in excel 2007

    Dear thefiddler2,

    see below link hope you will find answer there.

    http://www.automateexcel.com/2005/07...maps_in_excel/
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Distance and mileage function to use with google maps in excel 2007

    Or try,

    http://winfred.vankuijk.net/2010/12/...e-spreadsheet/

    it will help you.........

  4. #4
    Registered User
    Join Date
    06-29-2013
    Location
    earth
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Distance and mileage function to use with google maps in excel 2007

    Many thanks to all that answered.
    Excellent Advice

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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