View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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.