1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

latitudes and longitudes Road distance calculation

Discussion in 'VBA Macros' started by AV114, Oct 11, 2018.

  1. AV114

    AV114 New Member

    Messages:
    14
    I'm looking to get road distances between 2 addresses. I have the latitude and longitudes of each address. The issue I have is I can't use the Haversine formula, as it's for mileage claims so needs to be road distances.

    I'm aware of the google API stuff, but not really sure how it works, or how I'd go about implementing something like that into my scripts.

    Can you please help me on this.

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,667
  3. AV114

    AV114 New Member

    Messages:
    14
    Yes, i have used the googleapi function but it's not working, could you please help me.
  4. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,113
    Go through link below.
    https://analystcave.com/excel-calculate-distances-between-addresses/

    And below (Google Distance API documentation), if additional parameter is needed.
    https://developers.google.com/maps/documentation/distance-matrix/intro

    Do note that you'll need to obtain API key from Google first. They no longer support keyless API request.

    Edit: I misspoke, they changed pricing just recently. Go over their documentation before using API. As pricing has changed to pay as you go plan, and you may need to turn on billing option before use of API (I haven't used Google API in a while and haven't tested).
    Last edited: Oct 11, 2018
    Thomas Kuriakose likes this.

Share This Page