ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lat and Lon coordinates from address (https://www.excelbanter.com/excel-programming/438858-lat-lon-coordinates-address.html)

Ernie Lippert[_2_]

Lat and Lon coordinates from address
 
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

JP[_4_]

Lat and Lon coordinates from address
 
Check out

http://www.codeforexcelandoutlook.co...ude-functions/

and

http://processtrends.com/pg_google_e...ng%20addresses

HTH,
JP


On Jan 26, 2:29*pm, Ernie Lippert
wrote:
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




All times are GMT +1. The time now is 07:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com