Forum Discussion
Macro to auto calculate distance on google maps?
Hello again,
I would like to know if it's possible to automatically bring the search result from google maps (or other applications such as bing, etc...) into a specific cell.
For example, in my sheet 1 I have "Paris" in cell A1 and "Lyon" in cell B1, and I want to show the distance between two cities in cell C1. Here, I need the driving distance, and not the lineal distance...
Also, the cities could change in the next sheet..
Every help would be greatly appreciated, thank you in advance ...!
You will need to get an API key before you can use the code.
See Excel Function to Calculate Travel Time and Distance using Google Maps API with VBA
1 Reply
You will need to get an API key before you can use the code.
See Excel Function to Calculate Travel Time and Distance using Google Maps API with VBA