Example(s) of the file names and how they relate to either the current date or a cell with a date in your workbook that wants to gain access to this other file.
Are we talking macro code, formulae, queries?