ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   generating zip code and county information from latitude andlongitude data (https://www.excelbanter.com/excel-programming/444612-generating-zip-code-county-information-latitude-andlongitude-data.html)

Ole Liseth

generating zip code and county information from latitude andlongitude data
 
I have several thousand addresses in Excel with street address, city
and state. I need to generate the zip code and county for each
address. I have a copy of Mappoint 2011 and it definitely knows what
zip and county these latitude and longitude coordinate lies. Somebody
was mentioning using the following calls to Mapoint to get the zip
codes.

Using the MapPoint objects:

GetLocation (map obj returns location obj)
StreetAddress (location obj returns streetAddress obj)
PostalCode (streetAddress obj returns string)

Does anybody have any experience with this type of programming? The
latitude and longitude information is stored in columns E and F
repectively on sheet1.

Are there similar calls for county?

Thanks,

Peter.


All times are GMT +1. The time now is 02:11 AM.

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