How do you keep the optimized order when exporting a waypoint list into Excel?

I believe that can be done programmatically. What have you tried?

I'm pretty sure there are tools by Eric Frost, Gilles Kohl, and Winwaed Software to do this.

I haven't tried anything beyond the normal capabilities of the program. My technical knowledge is a bit elementary; I was hoping for an "easy" solution. I'm not sure why Microsoft wouldn't make this ability part of the standard program. My company and I utilize this program to route 35 employees to over 5000 customer locations, making it unfeasible to manually sequense the exported routes. Also, each of the 35 routes changes every month so I need a solution that is easy for our staff to implement each time our waypoint list is updated. I heard rumors that there was a "patch" we could download that would keep the optimized order of stops for each of the routes.

Hi Brandon,

Nope, no patch. If you go to my website and download
the Ordered Stops Routing Demo, we can work on it
for your company together.

Mike Mattys

Or there's our RouteWriter product:

http://www.routewriter.com


The new version (dev started today!) will also do the opposite - create route from imported pins using a pre-specified order (eg. a sequence number field).

Richard