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

Calculate distances btwn many zipcodes?

This is a discussion on Calculate distances btwn many zipcodes? within the Development forums, part of the MapPoint Desktop Discussion category; Hi all, need some expert help. I am looking for the best way to calculate the driving distances between tens ...

  1. #1
    abss is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    1

    Calculate distances btwn many zipcodes?

    Hi all, need some expert help. I am looking for the best way to calculate the driving distances between tens of thousands of different zip codes. Ideally I'd like to be able to just import an excel file with the starting zip code in one column, the ending zip code in another column, and have Mappoint figure out the distances between. Don't mind to code it (please provide examples if you suggest a solution with code). Any help appreciated ASAP. Thanks!

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Calculate distances btwn many zipcodes?

    It will take a long time - no matter what you do - because in order to get driving distance, you must get driving directions.

    I'm sure this product has been optimized as much as possible and should do it for you.

    MileCharter: Create Mileage Charts with Microsoft® MapPoint®

    There was someone else offering code recently ... you'll have to look through the posts.

  3. #3
    andriy is offline Junior Member Yellow Belt
    Join Date
    Mar 2007
    Posts
    16

    Re: Calculate distances btwn many zipcodes?

    I've posted an example of the road distance VBA (for Excel) in the thread titled On Error Help - VBA...

    hope it helps,
    andriy

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel UDF to calculate distances using lat/lon
    By pherrero in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-10-2010, 10:15 PM
  2. zipcodes
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-16-2005, 09:31 AM
  3. Calculate distances
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-18-2004, 11:58 AM
  4. Calculate highway distances of a route
    By C72831 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-2003, 04:00 PM
  5. Showing Zipcodes
    By shaistasohail in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-03-2002, 07:03 PM

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