Google Maps Api Road Distance Between Two Points. In this article we will create an Excel function to calculate the distance between two addresses using the Google Maps directions API. I am to get the actual distance between two points coordinates using REST web services call like following.
And for this I will be using this library. See the VBA code here. For developers and enthusiasts google provide google distance matrix API to calculate the distance and duration between two places.
The Google Distance Matrix API is a service that provides travel distance and journey duration for a matrix of origins and destinations using a given mode of travel.
You can also measure distance between cities using this module. This will allow you to get the travel time between the two locations. TRAVELTIMEorigin destination api_key TRAVELDISTANCEorigin destination apikey. For example you can measure the mileage in a straight line between two cities.
