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--


--
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.

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



On Nov 7, 9:56 am, ryguy7272
wrote:
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 ahyperlinkinside my excel file. I have triedHyperlink
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 amnotdealing with a single file but 100's of
files. Some have the "#" and some don't.
Is there another way other thanhyperlinkto open this file?
I have tried several things with no luck.
I am about to throw in the towel.- Hide quoted text -

- Show quoted text -