Please excuse the use of English in a French NG.

This concerns a French addin called Morefunc and I was hoping to reach
someone who knows of this addin and who can communicate in English how
to get it to work.

I am using the INDIRECT.EXT function to get data from a closed
workbook.

Here is my formula:

=SUM(OFFSET(INDIRECT.EXT("'\\Media\400_B\Schedules \["&TEXT(B12,"yyyy-mm")&".xls]Input'!$A$3"),27*(DAY(B12)-1)+2-2*ROW($A$1),6,27,1))

B12 is the date reference that determines which file is being
searched. All of the files are named with the format of "YYYY-MM.xls"
(eg. Feb. 2008 is 2008-02.xls)

This returns a #VALUE! Error. It works Fine if the requested file is
open.

Anyone have any ideas or suggestions as to how to make this work on
closed files?

-Minitman