I have MapPoint 2004 and Excel 2000. I have a list of addresses for a
route in Excel that I want to import into MapPoint and then optimize
the route stops. I know I can import and show the addresses on a map,
but how do I optimize them???
thanks for your help,
mak

Call the Optimize method of the Waypoints collection. This will
create an optimized Route object in the map.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mak" wrote in message
oups.com...
I have MapPoint 2004 and Excel 2000. I have a list of addresses
for a
route in Excel that I want to import into MapPoint and then
optimize
the route stops. I know I can import and show the addresses on
a map,
but how do I optimize them???
thanks for your help,
mak

Once the addresses have been imported and are visible on the map, click
and drag to select all of the data points and right click. Select "add
pushpins as stops". This will add each address as a stop on the Route
Planner tool. Then view the Route Planner tool -- click the little red
car. At the bottom of that tool is an "Optimize Stops" function.

This function can take awhile depending upon the number and locations
of the addresses you wish to optimize.

Oh, and you'll want to be sure to select your own Start and End (first
and last addresses).

Hope this helps.


--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=396877

Thanks for your help - NOW I understand!
mak