View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve E Steve E is offline
external usenet poster
 
Posts: 62
Default How can I pass values in cells to hyperlink to get result

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?