MapForums
Community of VE/MapPoint Users and Developers
Map in same order as Excel input file
This is a discussion on Map in same order as Excel input file within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Is there an option to produce stops in the same order as the stops in an Excel input file? I ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
10-02-2006
| |||
| |||
| Map in same order as 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,         |
|
10-03-2006
| ||||
| ||||
|
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
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
|
10-06-2006
| |||
| |||
 oddly enough...
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. |
|
10-06-2006
| |||
| |||
|
Hi, You can do this in VBA. Just add the waypoints in the right sequence in the code.
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
 |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| strange order in the exported Excel flile | pileggi | MapPoint 2006/2009 Discussion | 0 | 07-29-2005 10:08 AM |
| Export in Optimized Order to Excel | erkorb | Wish List | 1 | 12-06-2003 12:24 PM |
| Is there a way to input lines (ideally from Excel .... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 07-01-2002 07:21 AM |
| i have a file in excel that is over 2000 and mappo.... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 11-14-2001 08:55 AM |
| I want to be able to export to excel a file that h.... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 07-18-2001 12:29 PM |
All times are GMT -5. The time now is 05:19 PM.
