Hyperlink function in Excel 2000

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
 
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top