MAPPOINT Q & A

Top | Post New Question | Read All | MP2K Asks Microsoft

405 Joshua - September 19, 2001

I am currently running Mappoint 2001 and will buy 2002 if it can do the following: I want to plot routes for each of my 300 employees to five different work locations and export ONLY the distances for each to an excel spreadsheet. Can I do this in Mappoint 2002? Joshua

Answer:

This can be done quite easily. The code needed to extract distances is actually in the MapPoint 2002 Programming Reference, under the Distance Property section.

Here is the code:

You can find the Programming Reference on http://msdn.microsoft.com/mappoint or in MapPoint 2002's Help.

This code then needs to be extended to save all calculated distances in an Excel workbook. Again, this is a simple programming task.

Post New Answer / Follow-up

	MP2Kmag Internet