importing external data from changing file name
 

I would like to set up an external data link to import data from a text file
into excel. The problem is that I need the link to look for a new file name
each day. So, each day I need to import the data from the new file to the
same location in Excel. The names of the text files will always follow a
particular standard based on the current date (i.e. DATABASECCYYMMDD.TXT).

How can I have the link always import data from the text file with the
current date in its name?

Thank you,
Nathan