CALCULATE A LINK to a value
 

THANKS FRANK!!! YOUR SOLUTION WORKED AFTER INSTALLING THE
ADDIN!!



-----Original Message-----
Hi
if the other workbook is opened you can use INDIRECT. In
this case use:
=INDIRECT("[test.xls]sheet1'!b4")

But I would expect that the other workbook is closed (as
the above
INDIRECT function has no value).
See:http://tinyurl.com/2c62u for some alternatives
accessing closed
workbooks. In your example INDIRECT.EXT (from the
Morefunc.xll should
work). So try (after installing this add-in):
=INDIRECT.EXT("'c:\"& a1 & "\[test.xls]sheet1'!b4")


--
Regards
Frank Kabel
Frankfurt, Germany


aL wrote:
Column 'A1' contains 08-09-03

Cell 'B1' contains "='c:\"& a1 & "\[test.xls]sheet1'!b4

The end result of b1 is ='c:\08-09-03\[test.xls]sheet1'!
b4

I've been able to create the link. However it does not
access the value that the link points to. Can this be
corrected? Thanks in advance

.