indirect function

[gozik]

I am using the indirect function to read date from several workbooks..
I couldn't find a way to read the data without having the other file
open. I would like to read the data from these files without havin
them open. Please advice

 

[Frank Kabel]

Hi
if you only want to get one cell from a different closed workbook you
may have a look at the Add-In MOREFUNC.XLL
(http://longre.free.fr/english)
use the function INDIRECT.EXT.e.g.
=INDIRECT.EXT("''C:\Documents and Settings\" & cell_ref1 & "\My
Documents\My folder\[" & cell_ref2 & cell_ref3 & ".xls]Expense
Statement'!$F$2")
thats is just replace your function INDIRECT with INDIRECT.EXT

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

Frank

 

[JE McGimpsey]

Indirect requires the workbooks to be open.

See Harlan Grove's post at

http://google.com/groups?&[email protected]

for several alternatives