|If you would have Googled something like excel variable hyperlink you would have gotten lots of hits and methods.|
Bottom line is you need to use the HYPERLINK function. Look it up in Excel help to see how it works.
You can do all sorts of things within the HYPERLINK function.
Here's just 2 examples:
- Get the file name from a cell:
=HYPERLINK("file:///c:\Documents and Settings\user\My Documents\" & D1 &".xls", D1)
- Get part of the path from a cell using VLOOKUP:
=HYPERLINK("file:///c:\Documents and Settings\user\" & VLOOKUP(E1,C1:D10,2,0) &"\myFile.xls","Click Here")