VBA/EXCEL-How to find distance between coordinates when having the list of latitude and longitude coordinates

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Go back to All Questions Login or Register

I was looking at a tutorial on calculating distance between two coordinates. Link attached below. http://analystcave.com/excel-calculate-distances-between-addresses/#Calculate_distance_between_two_coordinates

In my case, i have the list of coordinates of latitudes and longitudes on spreadsheet (for about 59 stations). My ultimate goal is to find the roadway distance (mileage) and traveling time between all of the coordinates. I was hoping to do it by just using the VBA function without google API. Is this something possible?
How should i go about determining the duration using vba function?

Would appreciate if someone could help on this!

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match