Normally you would use the Indirect function, however it doesn't work with
closed workbooks If you open your workbook 2005October14.xls you can do:

=Indirect("'[" & CONCATENATE(TEXT(C3,"yyyymmmmdd"),".xls") & "]Daily
Report'!E5")

--
Regards,
Tom Ogilvy



"Mike Punko" wrote in message
...
ok I have a cell with the function.

=CONCATENATE(TEXT(C3,"yyyymmmmdd"),".xls")

Which gies me something like this.

2005October14.xls

I want to use that for a cell referance file name.

='W:\Aurora Daily Production Report\2005\10_Oct\[2005October14.xls]Daily
Report'!$E5

How to I get ths to work?