![]() |
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