Indirect to a closed workbook

[Guest]

Hi,

I use this to get values from another workbook =INDIRECT("'[Projects.xls]" &
B7 & "'!D" & J2) which works fine if the workbook [Projects.xls] is open. The
problem is I want to have the workbook [Project.xls] closed.

Any sugestion

thanks MarkS

 

[Bob Phillips]

You could try Harlan Grove's PULL function. You can get it
ftp://members.aol.com/hrlngrv/ (look for pull.zip)

You would use it like so

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!"&"B5")

or

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!B5")

Alternative

As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from


http://xcell05.free.fr/english/


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)