Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
using values entered in cells to determine a result in another cel | Excel Discussion (Misc queries) | |||
Call VBScript from VBA, pass variable, return result to macro? | Excel Programming | |||
How can I pass an array as TextToDisplay to a hyperlink? | Excel Programming | |||
can variables pass values | Excel Programming |