You can use the Google Maps Directions API to calculate travel time and distance using a number of travel modes. You can used VBA-JSON to create an Excel function that provides this data in Microsoft Excel! In this video, we create both travel time and travel distance functions in Excel VBA.
Links:
Written tutorial: [ Ссылка ]
VBA-JSON: [ Ссылка ]
Directions API Start (Get an API Key): [ Ссылка ]
Recommended book: [ Ссылка ]
![](https://s2.save4k.ru/pic/_P2lj4yHNu4/maxresdefault.jpg)