Calculate distances btwn many zipcodes?

abss
10-01-2007, 10:05 AM
Hi all, need some expert help. I am looking for the best way to calculate the driving distances between tens of thousands of different zip codes. Ideally I'd like to be able to just import an excel file with the starting zip code in one column, the ending zip code in another column, and have Mappoint figure out the distances between. Don't mind to code it (please provide examples if you suggest a solution with code). Any help appreciated ASAP. Thanks!

Mattys Consulting
10-01-2007, 04:58 PM
It will take a long time - no matter what you do - because in order to get driving distance, you must get driving directions.

I'm sure this product has been optimized as much as possible and should do it for you.

MileCharter: Create Mileage Charts with Microsoft® MapPoint® (http://www.mapping-tools.com/milecharter/index.shtml)

There was someone else offering code recently ... you'll have to look through the posts.

andriy
10-03-2007, 12:25 PM
I've posted an example of the road distance VBA (for Excel) in the thread titled On Error Help - VBA...

hope it helps,
andriy

 
Web mp2kmag.com
mapforums.com