Referencing cells in closed external workbooks

  • Thread starter Thread starter mmorris
  • Start date Start date
M

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