Forum Discussion

Soran0311's avatar
Soran0311
Copper Contributor
May 20, 2021
Solved

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 ...!

Resources