Indirect function only for open workbooks?

[Kurt]

Hi, I have a problem where I'm trying to use the Indirect
function or something similar to grab data from a cell
whose address is refereced in another cell, hence the
indirect. The problem I have is it appears all workbooks
I'm referencing have to be open. By using reference cells
on workbook "A", I'm identifying the workbook, worksheet
and row/col of the data I'm importing. I can use this
formula but again, the second workbook has to be open

=INDIRECT("'["&T61&".xls]"&U61&"'!"&V61)

Where T61 contains the workbook name, U61 the worksheet
and V61 the col/row address. Can anyone tell me if there
is a way to do this using another function or can Indirect
grab data from closed workbooks?

Thank you,

Kurt

 

[Frank Kabel]

Hi Kurt
INDIRECT can only work with open workbooks.

If the other workbook is closed try the following: have a look at the
Add-In MOREFUNC.XLL
(http://longre.free.fr/english)

use the function INDIRECT.EXT.e.g.
=INDIRECT("'C:\Temp\["&T61&".xls]"&U61&"'!"&V61)

that is just replace your function INDIRECT with INDIRECT.EXT and add
the path information to your file

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u