Well I have figured out how to get the waypoints into MapPoint 2006, now how do I get the optimized result? :/

I have tried the For Each...Next loop with both the Waypoints collection and the Directions collection. I haven't been able get the result I need. I'm looking for a list of the optimized route with the elapsed time and the elapsed distance next to each waypoint.

code segment:
For Each D In .Directions
idx = D.Index
ActiveCell.Offset(1, 0).Activate
If D.Type = 9 Then
objRoute.Directions.item(idx).Waypoint.Name
End If
Next

When shorthand notation didn't work I also tried it with the full reference. Neither one have worked. So obviously I'm missing something.

I keep getting "Object dosen't support this item or method" error.

Does anybody have any suggestions.

TIA
Mike

how are you optimizing the route, with the ruote optimization function included in MapPoint, or some other way?

Are you trying to optimize it with your for next loop, and just want help with the coding, or are you looking for that functionality before you export to excel?

Originally Posted by alexramo

how are you optimizing the route, with the ruote optimization function included in MapPoint, or some other way?

Are you trying to optimize it with your for next loop, and just want help with the coding, or are you looking for that functionality before you export to excel?

Thanks for the help. I know how to optimize the route, that part was easy.
.Waypoints.Optimize
.Calculate

Now that I have the route how do I list the result back into Excel? Here is the workflow I'm looking for. I list the addresses I want for the route. With the start and end point being the same place for a round trip. Then I load them in as waypoints, optimize them, do the calculation. Now I want to list out the optimized route into Excel along with the cumulative distance and time. I only want to show the waypoints, not all of the driving directions.

I should explain it's not the Excel part, I know how to put values into cells. The part I am having trouble with is the MapPoint part. How do I get the information from MapPoint about each of the waypoints in the new optimized order, with distance and time?

Thanks
Mike

check out this website,
RouteWriter: Export Microsoft MapPoint Route WayPoints to Excel

Mappoint doesn't have the functionality to export your points in the order you optimized them( i have no idea why, seems to me thats one of the first things they should have thought about!)

this tool will export them in your optimized route.

Hope that helps.

There's also another programmer on these mapPoint forums, his name is Mike Matty's he helped me in the past with a problem, I wanted to draw my route and export my pushpins in that particualr order, and aslo have the distance between them, and total distance. it was pretty cool and useful.

You can contact him at
Mattys Consulting - Custom Programming

good luck.

Originally Posted by alexramo

check out this website,
RouteWriter: Export Microsoft MapPoint Route WayPoints to Excel

this tool will export them in your optimized route.

Hope that helps.

You can contact him at
Mattys Consulting - Custom Programming

good luck.

Ahh, money. I am a small cog in a large organization, and I don't the authority to spend money for the corp. I can use what we already have, such as Excel and MapPoint, to create the tools I need, but I am not allowed to buy or even install new software. Our computer network is very controlled.

But, thank you anyway.
Mike