MapForums

If I have the geocodes for a large list of pushpins in a spreadsheet, is there a way to program MapPoint to run the distance and drivetime to another geocode for each?

Point 1 -> Point 2
Point 3 -> Point 4
Point 5 -> Point 6

In other words, just go down the list like above and output the distance and drive time.

Thanks,

wino

A one-to-one relationship like you describe is best handled with a little bit of custom programming.

If you know a little bit of VB then it should be easy enough. You will need to read each row in turn. Create MapPoint Location objects with each 'geocode', and find a route. From the route you can then measure the distance, and save it to the spreadsheet.


(if you were after a one-to-many or many-to-many relationship then off-the-shelf tools exist including my own MileCharter program)


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