Lat and Lon coordinates from address

[Ernie Lippert]

Given a street, city, and state address how can I find the Lattitude and
Longitude coordinates? I know I can do this for individual addresses via
Google World but I would like to program a spreadsheet macro so that I could
populate x addresses with their (Lat, Lon) coordinates.

[JP]

Check out

http://www.codeforexcelandoutlook.com/excel-vba/latitude-longitude-functions/

and

http://processtrends.com/pg_google_earth.htm#Converting%20addresses

HTH,
JP


On Jan 26, 2:29 pm, Ernie Lippert

Post by Ernie Lippert
Given a street, city, and state address how can I find the Lattitude and
Longitude coordinates? I know I can do this for individual addresses via
Google World but I would like to program a spreadsheet macro so that I could
populate x addresses with their (Lat, Lon) coordinates.
--
Regards,
Ernie Lippert