Welcome to MapForums!

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

## Fast Calculation of Driving Distance between 2 points

This is a discussion on Fast Calculation of Driving Distance between 2 points within the Wish List forums, part of the MapPoint Desktop Discussion category; I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map ...

1. Junior Member Yellow Belt
Join Date
Mar 2003
Posts
13

## Fast Calculation of Driving Distance between 2 points

I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map were not drawn and the itinerary not created these values could be returned much faster?

2. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## Re: Fast Calculation of Driving Distance between 2 points

Originally Posted by Bob Chase
I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map were not drawn and the itinerary not created these values could be returned much faster?

3. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
Totally - I'm using MapPoint within an Excel MAcro and the calculate method looks SLOW. Any faster ways of getting driving distance between two points I don't know of?

4. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

5. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
We are in the middle of building a table of locations (more than a thousand locations, actually) with distances between each location pair. The end result is a pivot table of all of our locations, with mileages noted (not unlike the mileage grids one might find in maps and atlases. We have an Excel macro that grabs the mileages from MapPoint right now. It's not very efficient (yet), but it's reasonably fast. When it's done we can post it here.

6. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## mappoint matchmaker software

I think that what you need is this:

http://www.tufat.com/script.php?id_num=8

This program basically take in 2 Excel spreadsheets and computes a table of driving distances from them.

7. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

## distances

Hi everybody,

I would like to calculate ditances between a list of zipcodes and one town.
These zipcodes are in an excel file.
Mappoint match maker won't allow me to do that because it needs full adresses. Do you know another way of doing that ( could you please give me your macro even if it is slow?)

Thank you very much

Sebastien