I am trying to get a mileage from 2 zip codes

EXAMPLE:
http://www.transystem.com/ptToPtMlg/ptToPtMlgCalc.cfm

I would like to do this from within a worksheet to achieve a mileage then be
able to use that mileage to formulate rates.

Any suggestions how the example was done and how do I go about doing
this.......

I know what to do with the rates once mileage is gained but I need to get
the mileage..

Thanks
David Poe

I would guess they have a database that has latitude and longitude for each
zip code and computes the difference between them. If it is more complex
than that, then they would have to have route information between the cities
I suspect.

In any event, unless by your question you mean to manipulate the web page
from excel to get the mileage, to provide similar functionality in Excel you
would need a similar database.

--
Regards,
Tom Ogilvy





"David Joseph" wrote in message
. com...
I am trying to get a mileage from 2 zip codes

EXAMPLE:
http://www.transystem.com/ptToPtMlg/ptToPtMlgCalc.cfm

I would like to do this from within a worksheet to achieve a mileage then
be
able to use that mileage to formulate rates.

Any suggestions how the example was done and how do I go about doing
this.......

I know what to do with the rates once mileage is gained but I need to get
the mileage..

Thanks
David Poe