Creating a distance file between two cities
Solved
jenny-eg
Posted messages
10
Status
Membre
-
jenny-eg Posted messages 10 Status Membre -
jenny-eg Posted messages 10 Status Membre -
Hello
I need an Excel spreadsheet with the distance between two cities including all the cities in the 22.
I have listed the 400 or so cities in the x-axis and y-axis to fill in all the distances in the body of the table.
But searching for all the distances on Mappy will be very, very long since there will be at least 84,000....
I've seen a tutorial on YouTube where the gentleman used VBA to look up distances on the site between two cities. The problem is: I can't find my cities because they are too small on this site.
Is it possible to fill out my table faster than by hand using the Mappy site?
PS (GS): I don't know VBA at all but I'm very interested, so it's now or never ;)
https://www.cjoint.com/c/KIbjoyE3glJ
I need an Excel spreadsheet with the distance between two cities including all the cities in the 22.
I have listed the 400 or so cities in the x-axis and y-axis to fill in all the distances in the body of the table.
But searching for all the distances on Mappy will be very, very long since there will be at least 84,000....
I've seen a tutorial on YouTube where the gentleman used VBA to look up distances on the site between two cities. The problem is: I can't find my cities because they are too small on this site.
Is it possible to fill out my table faster than by hand using the Mappy site?
PS (GS): I don't know VBA at all but I'm very interested, so it's now or never ;)
https://www.cjoint.com/c/KIbjoyE3glJ
1 réponse
Hello,
check this out, ready to use:
https://www.excel-pratique.com/fr/telechargements/utilitaires/itineraire-google-multi-adresses-excel-no513
--
@+ The Pivert
check this out, ready to use:
https://www.excel-pratique.com/fr/telechargements/utilitaires/itineraire-google-multi-adresses-excel-no513
--
@+ The Pivert
Thank you very much for your response.
I created an API key, I am testing with starting and destination addresses but it says "request denied" next to the total distance. It’s strange. I tried spaces, commas...
My requirement is to just use the postal code and the city but no address, so will that work?
I'm very interested in the save tab.
It's a great file, we just need to figure out what's causing the bug...
This file requires a Google API key to function.
To obtain your own API key: https://developers.google.com/maps/documentation/distance-matrix/get-api-key
The key must then be entered in the cell "KEY TO ENTER HERE"