Creating a distance file between two cities
Solved
-
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 answer
-
ContributorHello,
check this out, ready to use:
https://www.excel-pratique.com/fr/telechargements/utilitaires/itineraire-google-multi-adresses-excel-no513
--
@+ The Pivert-
Hello,
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... -
@jenny-egHello,
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" -
Contributor@jenny-egsee here the tutorial to create your key
https://forum.excel-pratique.com/applications/itineraire-google-multi-adresses-148191
see you later -
@cs_Le PivertAH thank you very much sensei you are awesome I'm going to get to it tomorrow morning because right now I have another job to do...
but I'll give you news tomorrow I promise.
And thanks again -
@cs_Le PivertDo you need a debit card account for it to work?
I saw that it was free for the first 400 requests since I have to make 80,000...
-
