See your other post

--
Biff
Microsoft Excel MVP


"DA_Potts" wrote in message
...
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?