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 2 of 2

Automate large list of drive time & distance calculation

This is a discussion on Automate large list of drive time & distance calculation within the MapPoint Desktop Discussion forums, part of the Map Forums category; If I have the geocodes for a large list of pushpins in a spreadsheet, is there a way to program ...

  1. #1
    onegalacticwino is offline Junior Member White Belt
    Join Date
    Oct 2004
    Posts
    4

    Automate large list of drive time & distance calculation

    If I have the geocodes for a large list of pushpins in a spreadsheet, is there a way to program MapPoint to run the distance and drivetime to another geocode for each?

    Point 1 -> Point 2
    Point 3 -> Point 4
    Point 5 -> Point 6

    In other words, just go down the list like above and output the distance and drive time.

    Thanks,

    wino

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    A one-to-one relationship like you describe is best handled with a little bit of custom programming.

    If you know a little bit of VB then it should be easy enough. You will need to read each row in turn. Create MapPoint Location objects with each 'geocode', and find a route. From the route you can then measure the distance, and save it to the spreadsheet.


    (if you were after a one-to-many or many-to-many relationship then off-the-shelf tools exist including my own MileCharter program)


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Distance Calculation
    By jburgess in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-06-2004, 09:33 PM
  2. hiding drive time box
    By chaching in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-30-2004, 03:45 PM
  3. Replies: 6
    Last Post: 08-19-2004, 07:10 PM
  4. Drive Time Addin
    By kez100 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-04-2004, 08:29 AM
  5. Drive Time Zones
    By EdB in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-24-2002, 07:09 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 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