You can download an add-in called Morefunc it has a function called
INDIRECT.EXT
that will work if the source book is closed

http://xcell05.free.fr/morefunc/english/index.htm


there is no built in function that can take a string referring to another
workbook that is not open and make it into a valid formula




--


Regards,


Peo Sjoblom


"ismae" wrote in message
...
Hi everyone!
I'm trying to make references from one book to another by using the
INDIRECT
function, but I found out it doesn't work when the source book is not
open.
Making the same reference without the INDIRECT function works ok.
The purpose of my application is to sum data from several books into one
summary book, but the names and quantity of books can vary dynamically, so
I
can't include them in my formulas.
Can anyone help me with this?