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?