Hi. I would like to be able to calculate the travel distance and time between two locations. This needs to be driving via the quickest road route, not a straight line. The locations will ideally be in 12 figure grid reference format, but I can convert that first if necessary. I have tried following various online articles covering a number of different APIs, but with little experience in this area I have had no success.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Travel Distance and Time
- Thread starter DanCull
- Start date
rpaulson
Well-known Member
- Joined
- Oct 4, 2007
- Messages
- 1,428
I have used this method in the past:
desmondoshiwambo.wordpress.com
How to get Google Travel Time and Distance in VBA by using Google Directions API … Desmond Oshiwambo style
How to get Google Travel Time and Distance in VBA
desmondoshiwambo.wordpress.com
Upvote
0
Similar threads
- Question
- Locked
- Question
