May 20 2021 04:38 AM - edited May 20 2021 04:40 AM
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 ...!
May 20 2021 06:49 AM
SolutionYou 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
May 20 2021 06:49 AM
SolutionYou 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