This is a tricky one; I am importing data from an application that logs appointments for properties. The map shows the properties for which a new appointment exists as pushpins, located by UK postcode.

The data set I am importing also contains a start and end time for the appointment.

I am then using the route finder function, and I am selecting all the pushpins on the map and adding them to the route as stops.

What I want to know is; is there any way in which I can get the routing functions to read the 'start time' of the appointments (held in the data set) and to then order the stops by start time, before calculating the route?

Or am I just mad?

I have the North America Version, but see if you can use the PreferredArrival property of the Waypoint object when you add the waypoints to the map.

Returns or sets the preferred arrival time at a stop or the end point on a route; similar to clicking Schedule Stop on the Route menu. Returns an error for the start point. Returns midnight if not set. Read/write Date.

Code:

  'Set the time you'd like to arrive at the end point
  objRoute.Waypoints.Item(2).PreferredArrival = TimeValue("1:00:00 PM")