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