You could try VBA
Workbooks.Open Filename:="I:\Excel\Document " & Format(Date, "dd-mm-yy") &
".xls"

you could try building a link in one of your worksheets using
=INDIRECT("'I:\Excel\[Document "&TEXT(TODAY(),"dd-mm-yy")&".xls]Sheet1'!$A$1")

but excel's native indirect function does not work on closed workbooks. You
could check out Laurent Longre's Indirect.ext function included with the
Morefunc addin

http://xcell05.free.fr/morefunc/english/index.htm

"Love2Learn" wrote:

I'm chasing a VBA string that will open a file which is renamed every day.
Files are identical but are renamed with "todays date". e.g. 'document
28-01-09'.
OR
Is there a formular which will lookup/reference this file being renamed
daily. Cell location of data is identical in each file.

My objective is to overwrite data in an existing "Temp" file which links to
a ppt. daily presentation.

Thankyou