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

I have been using MapPoint to sequence route stops....

This is a discussion on I have been using MapPoint to sequence route stops.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have been using MapPoint to sequence route stops using the Optimize Stops tool. Once I do this, is there ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I have been using MapPoint to sequence route stops using the Optimize Stops tool. Once I do this, is there a way to have MapPoint pull linked data into an Excel spreadsheet in the order in which the stops have been optimized?

  2. #2
    Walt Cygan is offline Senior Member Green Belt
    Join Date
    Aug 2002
    Posts
    124
    I am assuming that you want to put route information into a spreadsheet in the order of optimized stops. The answer is that this can certainly be done using code. Once a route is optimized, the order of the Waypoints in the Directions collection is set based on the optimization. All you need to do is go through the Directions or the Waypoints collections (depending on how much and what information you want to get) and then use Excel automation or ADO data access to write data to Excel.


    See MapPoint programming Help for details on the properties of the Route, Direction and Waypoint objects to see what data is available and where. For example, you only get DrivingTime as a property of a Route object, StopTime is only a property of Waypoints and StartTime is only available from a Direction object.


    - Walt Cygan

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. retrieving directions in a route with stops
    By couso in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-04-2006, 03:19 PM
  2. How do you loop through the stops on a route?
    By petemarkham in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-11-2003, 11:06 AM
  3. Extracting the route sequence
    By ivtch in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-11-2003, 03:29 PM
  4. Connect Route Stops?
    By swberman in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-11-2003, 09:29 PM
  5. We created a route of 700+ stops and optimized it.....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-07-2001, 05:27 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