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