Referencing a closed file
 

I am using the indirect function to reference cells in another Workbook. I
would like the reference to the files without them being open. Is there a
way to do this?
I was told that it can be done by using the full file path in the reference?
Is this true? How should it be entered?

You can NOT use indirect with a closed workbook.

--
Don Guillett
SalesAid Software

"briancrosier" wrote in message
...
I am using the indirect function to reference cells in another Workbook.
I
would like the reference to the files without them being open. Is there a
way to do this?
I was told that it can be done by using the full file path in the
reference?
Is this true? How should it be entered?

You can not refernce a closed file using INDIRECT, here's a workaround

http://www.google.com/groups?selm=sH...wsranger. com

On one line

how to install macros

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Regards,

Peo Sjoblom



"briancrosier" wrote:

I am using the indirect function to reference cells in another Workbook. I
would like the reference to the files without them being open. Is there a
way to do this?
I was told that it can be done by using the full file path in the reference?
Is this true? How should it be entered?