SOLVED

Macro to auto calculate distance on google maps?

Copper Contributor

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

1 Reply
best response confirmed by Soran0311 (Copper Contributor)
Solution

@Soran0311 

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 best response

Accepted Solutions
best response confirmed by Soran0311 (Copper Contributor)