Hyperlink or not??

  • Thread starter Thread starter rpick60
  • Start date Start date
R

rpick60

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.
 
I've used this with success:
=HYPERLINK("C:\Test" & 'Link to Folder'!C1,"Test Folder")

Modify to suit your needs.
Ryan--
 
Ryan
Thanks for the info, but I am not having any luck with your
suggestion.
Here is what i am trying to link to.

C:\testfile.xls
C:\testfile#1.xls

Here is the hyperlink that works to the first file =HYPERLINK("C:
\" &"testfile.xls","testlink")

I cannot get the one to the second file (with the # sign) to work.
What am i missing?
Any suggestions?

Ralph
 
Back
Top