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

Extracting the route sequence

This is a discussion on Extracting the route sequence within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have created a route of 20 stops - each stop is a customer with its account number. How can ...

  1. #1
    ivtch is offline Junior Member White Belt
    Join Date
    Mar 2003
    Posts
    5

    Extracting the route sequence

    I have created a route of 20 stops - each stop is a customer with its account number. How can I extract the route sequence that MapPoint creates (which customer is what stop number)?

    Thanks. Ivan

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    Use the Waypoints collection. The help file has a pretty good example that should get you started.

  3. #3
    sm176811 is offline Junior Member White Belt
    Join Date
    Mar 2003
    Posts
    7
    The following code snippet show how you can iterate through the directions list.

    Private Sub OKButton_Click()

    Dim g_oApp As New MapPoint.Application
    Dim objMap As MapPoint.Map
    Dim objRoute As MapPoint.Route

    'Set up the application
    Set objMap = g_oApp.ActiveMap
    Set objRoute = objMap.ActiveRoute
    'objApp.Visible = True
    'objApp.UserControl = True


    'Add route stops
    With objRoute.Waypoints
    .Add objMap.FindResults("Tacoma, WA").Item(1)
    .Add objMap.FindAddressResults("16955 SE 38th Street", "Vancouver", "WA").Item(1)
    End With

    ' Iterate through the Direction List
    Dim inx As Integer
    For inx = 1 To objRoute.Directions.Count
    MsgBox (objRoute.Directions.Item(inx).Instruction)
    Next inx

    objMap.Location.Highlight = True
    g_oApp.ItineraryVisible = False
    g_oApp.PaneState = geoPaneNone


    End Sub
    Sitting still and wishing makes no person great..
    The good lord and sent you fishing but you should dig the bait!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting street names from route Instruction
    By Curt in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 06-28-2010, 02:24 AM
  2. Letting MapPoint choose the waypoint sequence
    By BobFromBoston in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-21-2005, 07:43 PM
  3. Export to Excel - Sort Sequence
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-08-2004, 06:02 AM
  4. sequence of imported data changes
    By Harv in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-27-2003, 04:09 PM
  5. I have been using MapPoint to sequence route stops....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-04-2002, 10:31 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