The problem is the [ & ] and worksheet name that gets brought in.

Try this

=HYPERLINK(SUBSTITUTE(LEFT(CELL("filename",[data99.xls]journal!A1),FIND("]",
CELL("filename",[data99.xls]journal!A1))-1),"[",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VadimGor" wrote in message
ups.com...
Can I use a CELL function for extracting a workbook name for further
using in the HYPERLINK function.
Something like this HYPERLINK("[CELL("filename")]June!A1").
It is always gives an error or jsut build a wrong link.

Thanks