Indirect function only for open workbooks?

  • Thread starter Thread starter Kurt
  • Start date Start date
K

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
 
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
 
Back
Top