Sorry.

I figured this out using the worksheet function HYPERLINK(). Works great.

Now if I can just figure out how to capture the weblink data back...

"Steve E" wrote:

I am trying to pass address information located in cells to mapquest (or some
similar site) to find driving distance between two locations. Driving
distance is then used to calculate other costs in application. Cells are
named: "To_Street", "To_City", "To_State", "To_Zip" and "From_Street",
"From_City", "From_State", "From_Zip"

The hyperlink url should end up something like
http://www.mapquest.com/directions/m...S&cid=lfddlink

This would allow my user to click on the url and get the mapquest site to
open with the addresses entered so that they have to click on the "get
directions" and then manual enter back in the driving distance (I'd really
like to automate that but I don't think I'm up to that yet.

Is this possible from within Excel?