MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Route Optimizing Software Question

This is a discussion on Route Optimizing Software Question within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am trying to import an excel file with addresses, then optimize the stops and export them back to excel. ...


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 Thread Tools Display Modes
  #1 (permalink)  
Old 06-09-2006
Junior Member
White Belt
 
Join Date: Jun 2006
Posts: 2
Route Optimizing Software Question

I am trying to import an excel file with addresses, then optimize the stops and export them back to excel. I know MapPoint connot do this.

Does anyone know of another software product that can accoplish this task?

Thanks for your help in advance.
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 06-09-2006
Junior Member
White Belt
 
Join Date: Mar 2006
Posts: 2
It can do that...

You will need to write some VBA code in Excel, but you can do what you describe. Suggest you refer to article on coding MapPoint from Excel at http://www.mp2kmag.com/a124--excel.udf.mappoint.html

This article refers to creating an Excel function but the principles can be used in any VBA code.

I have written a full application for route planning using this logic and while very crude coding, it works well. (At some stage Richard might get round to publishing it;).
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
optimizing, question, route, software


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
Consumers Trust Software Makers to Develop Car Software Eric Frost News and Announcements 0 04-17-2005 09:06 AM
Route Scheduling Software (HELP!) Anonymous MapPoint 2006/2009 Discussion 3 03-23-2005 02:48 PM
Export a route to a PocketPC navigation software like TomTom Anonymous MapPoint 2006/2009 Discussion 0 03-21-2005 08:52 AM
Route Optimizing with 2 identical stops cwrude MapPoint 2006/2009 Discussion 0 01-19-2005 02:28 PM
TruckStops Route Scheduling Software v2.9 Adds Features Eric Frost News and Announcements 0 10-07-2003 06:55 PM


All times are GMT -5. The time now is 01:17 AM.


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 55