MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Import stops in route order using excel

This is a discussion on Import stops in route order using excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I work for a transportation company and quite often we are supplied specific routes to run in the order which ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack (5) Thread Tools Display Modes
  5 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 07-12-2007
Junior Member
White Belt
 
Join Date: Jul 2007
Posts: 2
Import stops in route order using excel

I work for a transportation company and quite often we are supplied specific routes to run in the order which the company requires. When importing the stops in Mappoint 2006, the stops are not in the order on the excel spreadsheet. Is there a method to accomplish this task? Quite often each route exceeds 100 stops.

Thanks
Bob
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 07-13-2007
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,122
Re: Import stops in route order using excel

Hi Bob,

As far as I know you can only change the order programmaticaly (is that the right word?). Do you have possibility or knowledge to do something in VBA or whatever language ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 07-13-2007
Junior Member
White Belt
 
Join Date: Jul 2007
Posts: 2
Re: Import stops in route order using excel

Wilfried,

I thought this would be the case. I will address this with our IT department to see if there is an interest in helping.

Bob
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
excel, import, order, route, stops


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/import-stops-route-order-using-excel-6062.html

Posted By For Type Date
Advanced GPS For MapPoint - AGPS - MP2K Magazine This thread Refback 07-20-2007 11:04 AM
MapPoint Download - MP2K Magazine This thread Refback 07-19-2007 07:05 AM
Lat/Long in MapPoint 2002 - MapPoint Articles - MP2K Magazine This thread Refback 07-12-2007 06:25 PM
Microsoft MapPoint 2006 - MP2K Magazine This thread Refback 07-12-2007 11:11 AM
Programming MapPoint in .NET - MP2K Magazine This thread Refback 07-12-2007 11:11 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Map in same order as Excel input file gborge MapPoint 2006/2009 Discussion 3 10-06-2006 01:45 PM
strange order in the exported Excel flile pileggi MapPoint 2006/2009 Discussion 0 07-29-2005 11:08 AM
Export in Optimized Order to Excel erkorb Wish List 1 12-06-2003 01:24 PM
Import stops in Access Anonymous MapPoint 2006/2009 Discussion 1 09-19-2003 03:05 PM
Extract route order Anonymous MapPoint 2006/2009 Discussion 3 09-17-2002 10:11 PM


All times are GMT -5. The time now is 03:38 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54