CALCULATE A LINK to a value

A

aL

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
 
F

Frank Kabel

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")
 
A

Al

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

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
Click to expand...

.
Click to expand...
 
Top