Hyperlink function in Excel 2000

[neeraj]

I am using hyperlink function excel 2000. When I type the
entire file name and path in the function it works
perfectly e.g.
=hyperlink("[c:\file.xls]sheet1!a1, "Cell A").

But if I type the file with path in a cell and display
value in separate cell, and when I use these cell
references in the hyperlink function like
=hyperlink(a2,b2), then I get an eror message "Cannot open
the speciied file". Since I am building dymamically the
URL, its getting problematic for me.

Can someone explain if I am mising anything.
Thanks in advance
Neeraj

 

[David McRitchie]

Hi Neeraj,
In your example you left out a double quote for the link,
Think you want.
=hyperlink("[c:\file.xls]sheet1!a1", "Cell A").

the following should also work, no quotes in B4
B4: [c:\file.xls]sheet1!a1
C4: =hyperlink(b4,"Cell A")

I have examples of hyperlink worksheet functions in
http://www.mvps.org/dmcritchie/excel/sheets.htm

Since you are building the link in worksheet functions
suggest you also display separately the results of the
leftside of the they hyperlink function until you have it
working properly. So that you can tell exactly what
Excel is seeing when you see "cannot open the
specified file".