Excel - VBA Macro to calculate distance and time between multiple sets of addresses
$15-20 USD
Cancelado
Publicado há quase 12 anos
$15-20 USD
Pago na entrega
I have a spreadsheet of many pairs of addresses (starting and ending) and I'd like a Excel VBA macro that automatically calculates the distance/travel time between them.
There's code for this that already exists, using the Google Maps API. If you search for it, there's several instances. One is here:
[[login to view URL]!msg/excel-macros/VDWa1NuD_Rs/2kJ2-WpfFbYJ
Another here:][1]
[[login to view URL]
H][2]owever, I'm having trouble getting these to work. Can you please produce a VBA macro that does work? I'm a pretty experienced excel user, so you won't have to hold my hand too much. I've attached a sample data set.
thanks!