Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating spaces in code ExcelMonkey Excel Programming 2 June 5th 08 07:49 PM
Can someone tell me how to enter a long latitude on an excel data lawmarch Excel Discussion (Misc queries) 2 August 12th 07 09:14 PM
Convert Zip Code to County Michael Excel Worksheet Functions 2 August 19th 05 09:01 PM
Zip - State - County dandigger Excel Discussion (Misc queries) 2 January 26th 05 08:54 PM
New Data Type - Latitude and Longitude Calculations Peter M[_3_] Excel Programming 2 January 6th 04 06:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"