Greetings,

I need to get data from a closed workbook. The problem is the name of
the workbook is variable according to what is in a date cell.

I have labeled my workbooks with dates in the format of:

yyyy-mm (eg. Feb. 2008 = 2008-02.xls)

B14 is a date that determines which workbook is being called and A3 is
the reference cell that the rest of the formula is looking for (didn't
copy that part of the formula here, not relevant)

Here is the problem area:

....INDIRECT("'["&TEXT(B14,"yyyy-mm")&".xls]Input'!$A$3")...

INDIRECT does not like to look into a closed workbook.

This works if the reference workbook is open. Opening the referenced
workbook is a problem due to memory restrictions.

Any help will be greatly appreciated.

-Minitman