Macro for calculating distance between 1000+ latitude and longitude of addresses

[Kavya]

Hi Everyone,

I am very new to Excel Vba and to this forum. I really need help in one of the macros that I want to write as part of my internship work.

I have a list (1125) of latitude and longitude of addresses. I want to write a macro, which will give me the distance between two latitudes and longitudes. And the same to be repeated for the remaining 1124 records(rows) .

I want it to be connected to either Bing maps or Google Maps who have a feature of geocoding API.

It would be great if someone could help me with this!

Many thanks,
Kavya

 

[DRSteele]

I don't know VBA. But I have dealt with this in another post http://www.mrexcel.com/forum/excel-...ongitude-coordinates-find-closest-office.html
.

Perhaps all of this can help you and anyone else wanting to write a VBA solution.

http://en.wikipedia.org/wiki/Great-circle_distance
BlueMM: Excel formula to calculate distance between 2 latitude, longitude (lat/lon) points (GPS positions)
Latitude And Longitude

Excel 2012
	A	B	C	D	E	F	G	H	I
20		h	m	s	Latitude	h	m	s	Longitude
21	Calgary	51	2	46	51.04611	114	3	24	114.0566667
22	Edmonton	53	32	43	53.54528	113	29	21	113.4891667
24	Great Circle distance (km)		280.5591
Sheet36

Cell Formulas
Range	Formula
E21	=B21+C21/60+D21/3600
E22	=B22+C22/60+D22/3600
I21	=F21+G21/60+H21/3600
I22	=F22+G22/60+H22/3600
C24	=ACOS(COS(RADIANS(90-$E$21)) *COS(RADIANS(90-$E$22)) +SIN(RADIANS(90-$E$21)) *SIN(RADIANS(90-$E$22)) *COS(RADIANS($I$21-$I$22)))*6371

 

[Exceluser15]

Thank you Dr.Steele. It was kinda helpful