MPRouteWriter

Description

MPRouteWriter add-in imports and exports waypoints for Microsoft MapPoint routes whilst maintaining their route order. RouteWriter exports waypoints and their matching pushpins to Excel with their waypoint distance, time, coordinate, address data, and all available pushpin data fields. Routes can also be optimized. Pushpins can be matched to waypoints using two different methods. They can be matched on name (unreliable if duplicate names exist); or name and distance (slower but reliable). RouteWriter includes 'RouteReader' which is used to import routes from pushpins in a pre-determined order. This order is specified by a pushpin data field (typically a column that is imported using the Data Import Wizard). This field can be text or number, although it is usually a simple sequence number. Sorting can be in both ascending and descending order. Pushpins can also be selected by 'group' within a pushpin set. This feature allows all locations (e.g. customers) to be imported at once.