Referencing cells in closed external workbooks

[mmorris]

Hi,

I'm trying to build a formula that pulls a value from a cell in
closed workbook using INDIRECT. INDIRECT works fine when the othe
workbook is open but not at all when it is closed. Is there anothe
function that does this? One can reference external files via a direc
formula link but it doesnt work when one needs to assemble the formul
first.

All help greatly appreciated.

Thanks Mike
PS for what its worth heres the formula

=INDIRECT("'U:\Support Services\Models\[MM "&D5&" model.XLS]ARB'!$A1")
where d5 contains enough text to successfully build the file nam

 

[Frank Kabel]

Hi
Alternatives:
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. (if cell A1 stores the reference)
use:

=INDIRECT.EXT("'U:\Support Services\Models\[MM "&D5&"
model.XLS]ARB'!$A1")

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