Can You Use A Cell Reference in a Hyperlink?

[xfreez99]

I'm wondering if there is a way i could use a cell reference in an internal hyperlink such as

=hyperlink(C:\windows\:::CELL REFERENCE HERE:::\file.pdf,x)

[martindwilson]

example put =HYPERLINK("http://www."&b1&".com")in A1
put google in b1 and away you go
same for c:\ so
=HYPERLINK("C:\Documents and Settings\"&B1&"\Desktop\delete.txt")
if i put martin wilson in b1
then
C:\Documents and Settings\martin wilson\Desktop\delete.txt
it opens delete.text from my desktop

[xfreez99]

awesome thank you

i assume it works for the actual file name as well

if it does

you just saved me lots of time...

[martindwilson]

yep ,example
=HYPERLINK("C:\Documents and Settings\Martin Wilson\Desktop\"&B1&".txt")
put
delete
in b1
and delete.txt opens with url
tip use the friendly name for the hyperlink or it appears somewhat truncated when doing it like this