Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Extract Lat/Long by Zip Code

This is a discussion on Extract Lat/Long by Zip Code within the MapPoint Desktop 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 ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    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

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lat/Long of my Postal Code
    By jamesbond in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 11-29-2005, 06:47 PM
  2. setting up macro in excel to extract lat/long from map point
    By TransportationNut05 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-24-2005, 11:45 AM
  3. Replies: 0
    Last Post: 04-01-2005, 10:31 AM
  4. UTM to Lat / Long ?? Anybody know of code??
    By mnman in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-01-2004, 08:39 PM
  5. How to obtain ZIP code from lat-long?
    By BC in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-29-2003, 06:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96