Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generating spaces in code | Excel Programming | |||
Can someone tell me how to enter a long latitude on an excel data | Excel Discussion (Misc queries) | |||
Convert Zip Code to County | Excel Worksheet Functions | |||
Zip - State - County | Excel Discussion (Misc queries) | |||
New Data Type - Latitude and Longitude Calculations | Excel Programming |