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

Measure distance and time traveled

This is a discussion on Measure distance and time traveled within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have about 700 sites across the country that I have in a spreadsheet. I have imported them into MP ...

  1. #1
    chashutch is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Measure distance and time traveled

    I have about 700 sites across the country that I have in a spreadsheet. I have imported them into MP 2004 and they actually all show up and all 9 digit zip codes are correct.

    I would like to know if there is an automated way to determine the driving distance and time between about 50 of these sites (hubs) and the rest of them based on which hubs are designated to support which sites? I would then like to export all of the info back into excel for analysis.

    Thoughts?

    Thank you all.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Measure distance and time traveled

    This can definitely be done, but you need to do a little custom programming.

    You could either do a function that you would put in an Excel formula or it's probably better just to program it in VBA.

    There are some pointers as well as lots of examples to get you started with Excel VBA programming controlling MapPoint at --

    Working With Excel and MapPoint

    Eric

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Distance and Time Traveled ??
    By chashutch in forum Products: Pushpin Tool, Single State Mapper
    Replies: 4
    Last Post: 09-30-2010, 08:23 AM
  2. How do you create a time to distance map?
    By Integraoligist in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-01-2007, 04:52 PM
  3. Measure Distance to 1/100th mile?
    By ekrupa in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-14-2007, 04:36 AM
  4. Distance/Drive Time
    By stwilber in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-10-2006, 11:13 AM
  5. Is Measure Distance available in Mappoint Control
    By spideybud in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-04-2004, 10:13 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