Open the Visual Basic Editor (Alt + F11). You can download the latest version from here. Step 1: Create a new macro file and add VBA-JSONīecause the Google Maps Directions API is a JSON API, we will use VBA-JSON to make it easy to use the results from the web request. Create a new project and make sure the Directions API is added. The “Getting Started” page can help you with this. In order to use the function, an API key is required. The origin and destination will be strings, and can be either an exact address or the name of a place. The format of the function will be as follows: =TRAVELTIME(origin, destination, api_key), =TRAVELDISTANCE(origin, destination, apikey). This will allow you to get the travel time between the two locations. In this article, we will create an Excel function to calculate the distance between two addresses using the Google Maps directions API.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |