Excel Distance between cities

[tomstowell]

Has any one develped an application to determine the distance between two cities.

I have the following.

city1 state1 City2 state2.

Ideally I would like to pull the info from mapquest.
I have thousands of lines and so would like to automate the process.

 

[Dimli]

there are some browser-based applications:

http://www.geobytes.com/CityDistanceTool.htm

or

http://www.symsys.com/~ingram/mileage/index.php
which uses the following formula:

http://www.symsys.com/~ingram/mileage/index.php?ok=about