|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!