View Full Version : Import a Route with Stoptimes

Eric Frost
08-20-2008, 11:19 AM
This tool allows you to import a route with stoptimes.

Each of the stops has a separate column to specify stop time in minutes.

This has been tested with MapPoint 2009 North America, but could easily be modified to work in any version of MapPoint.

Work on this was originally started for a question in this forum here:

It is very similar actually to the Route Optimization Tool in the MapPoint Power Tools Spreadsheet and the layout was patterned after that.

The Route Optimization and this StopTime tool could be combined if so desired, it should not be too hard for a VBA programmer to make the modification.

Depending on your needs if you are working with routing in MapPoint, you should also take a look at RouteWriter / RouteReader.
RouteWriter: Export Microsoft® MapPoint® Route WayPoints to Excel® (https://www.plimus.com/jsp/buynow.jsp?contractId=1730358&referrer=ericwfrost)


03-09-2011, 03:59 PM
How about importing depart at times?

Eric Frost
03-10-2011, 12:11 PM
I don't know how that would work. So you would specify a time of day at which you would depart from a stop? Or just specify the time you leave the Starting waypoint?


03-10-2011, 01:55 PM
Yes, I want the depart to time to be filled in from the imported data. It would be be helpful tool to audit drive time and miles completed. Route Reader does a great job importing the addresses in order of time with the waypoint order. Now if we can just push that same time to the depart at field in MapPoint. Then I can see down time between stops. In other words how early one arrives at a stop with a set depart time.

Eric Frost
03-10-2011, 02:04 PM
I think this could be accomplished with some custom work, I'll send you a PM.

From my understanding, essentially the program would determine the "stop time" on the fly based on the time the vehicle arrives at a stop and the depart time.

(If the depart time is earlier that the arrival time, the stop time would be 0.)

Let me know if this makes sense.


Eric Frost
04-20-2011, 09:20 AM
A very similar tool to this one has now been posted here --


The only tricky thing in code is that the last item in the Route cannot have it's Depart Time set in code, it says "Permission denied". So it has to go back afterwards and fill in the .PreferredDeparture properties after all the Waypoints are set up.