MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Extract Lat/Long by Zip Code

This is a discussion on Extract Lat/Long by Zip Code within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, I need to determine Lat/Long from Zip Codes. I want to do this by inputting a file of Zip ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-24-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Extract Lat/Long by Zip Code

Hi,

I need to determine Lat/Long from Zip Codes. I want to do this by inputting a file of Zip Codes and then adding the Lat/Long to this file. I would like to do this using Excel VBA, if possible. Does anyone know how to do this?

Thanks!
Sharon
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 11-25-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Hi,

Code:
            FindResults Results;
            Results = MP.ActiveMap.FindAddressResults("", "", "", "", zip, GeoCountry.geoCountryBelgium);
            foreach(object o in Results) {
                Location Loc = o as Location;
                if (Loc != null) {
                    // find lat/long from Location
                }
To find the Lat/Long from location there are at least 3 articles here. I dont have URL at hand, but please search in the article section.

rgds, Wilfried
http://www.mestdagh.biz
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 11-25-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Hi,

Just found the article (but there are more) on finding lat/long from location object:

http://www.mp2kmag.com/a13--kohl.ext....mappoint.html

rgds, Wilfried
http://www.mestdagh.biz
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
code, extract, lat or long, zip


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
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
Lat/Long of my Postal Code jamesbond MapPoint 2006/2009 Discussion 6 11-29-2005 06:47 PM
setting up macro in excel to extract lat/long from map point TransportationNut05 MapPoint 2006/2009 Discussion 2 08-24-2005 11:45 AM
Locate City and zip code using lat and long (Excel Macro) sberhe Wish List 0 04-01-2005 10:31 AM
UTM to Lat / Long ?? Anybody know of code?? mnman MapPoint 2006/2009 Discussion 0 12-01-2004 08:39 PM
How to obtain ZIP code from lat-long? BC MapPoint 2006/2009 Discussion 1 04-29-2003 06:49 AM


All times are GMT -5. The time now is 06:10 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55