How to get distance from one location to another from google maps

Hello,

 I would like to have distance in miles between several addresses.  As shown in the sample excel file, I would like to enter a location in a spreadsheet and distance from the previous location is automatically calculated .  So that I can calculate the total distance until returned to original location.  

 Thanks again,

 Mareeka
sample.xlsx
mareekaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
vb_elmarConnect With a Mentor Commented:
Here is a sample.
8.xls
0
 
vb_elmarCommented:
Can you provide it as an "old" XLS version?
0
 
plusone3055Commented:
there is no VB version of the google maps API...
 its done in javascript
so your going to have to have to use javascript functions to do this


one way would be to read the cells off the excel sheet  in vb and use javascript to
enter those as start/end points into the API  paste the results back to the excel sheet, then do a sum

https://developers.google.com/maps/documentation/javascript/tutorial
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
mareekaAuthor Commented:
0
 
vb_elmarCommented:
Here is another sample. It contains a route calculation for
Chicago, Greensboro, High Point and Seattle
sam3.xls
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
All Courses

From novice to tech pro — start learning today.