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 addresses

HTH,
JP