Is there an option to produce stops in the same order as the stops in an Excel input file?
I know the stop order can be changed with the Route Planner but that is too time consuming for the number of stops and routes we have.
Has anyone changed the routing algorithm with VB?

Thanks,

Custom programming (eg. with VB6) would be the best approach.
It just needs to read each row, geocode (if necessary), and then add the waypoint (and pushpin if necessary).


Spookily, the "RouteWriter" product I released last Friday does the exact opposite! Ie. exports route waypoints&pushpins to Excel whilst maintaining their order.

Richard

I was searching this forum for a way to do exactly what you are asking about. I would love to find a way to create a route directly from excel addresses (or even lat/long data).

Let me know if you either build/find the code to do this, and I will do the same.

Hi,

You can do this in VBA. Just add the waypoints in the right sequence in the code.