linked files with a changing name

[nisselyo]

I have a file that I name daily jumbo arms and then the date. I have another file that needs to be linked to this file. Im trying to use an indirect in the link {basically in another field I put ="jumbo Arms "&MONTH(N104)&" "&DAY(N104)&" "&YEAR(N104)&".xls" cell n104 is today() which gets me the actual file name and I tried to insert that via Indirect into my linked formula} but cant seem to get it right - can anyone help me?
Thanks

 

[Andrew Poulsom]

What is the actual file name, what does your concatenation formula return, and what INDIRECT formula did you try?

 

[nisselyo]

The actual file name is jumbo arms 8 15 07 (the date obviously changes daily). my formula just duplicates the file name - basically changes the date. I tried to link cell a1 of my new file to a1 of the file by using indirect of my formula which I thought would bring me to the file - but didnt.

 

[Andrew Poulsom]

If A1 contains the formula:

="jumbo arms "&MONTH(N104)&" "&DAY(N104)&" "&RIGHT(YEAR(N104),2)&".xls"

which returns:

jumbo arms 8 15 07.xls

then:

=INDIRECT("'["&A1&"]Sheet1'!A1")

will return the same as the formula:

='[jumbo arms 8 15 07.xls]Sheet1'!A1

 

[nisselyo]

For some reason Im still having problems with it - I tried to include directory but its just not working.

 

[Andrew Poulsom]

For some reason Im still having problems with it - I tried to include directory but its just not working.

The workbook must be open if you use the INDIRECT function. INDIRECT.EXT from the Morefunc add-in works with a closed workbook:

http://xcell05.free.fr/english/