Hyperlink or not??
I've used this with success:
=HYPERLINK("C:\Test" & 'Link to Folder'!C1,"Test Folder")
Modify to suit your needs.
Ryan--
--
RyGuy
"rpick60" wrote:
I am trying to figure out the best way to link to a file on my hard
drive from a hyperlink inside my excel file. I have tried Hyperlink
and it does work but when the filename has a "#" in it I get an
message that it cannot find the file. If i take it out it will work.
The problems is that i am not dealing with a single file but 100's of
files. Some have the "#" and some don't.
Is there another way other than hyperlink to open this file?
I have tried several things with no luck.
I am about to throw in the towel.
|