import 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

If your text file is automatically generated by a scheduled export from a
database, (in my case, overnight processing of GL, etc) I have the IT group
generate 2 text files. One with the date stamp to retain history and a
second with a Non-Changing file name, like: GLDOWNLOAD.TXT (overwriting the
file if necessary). That way, no special programming is necessary and links
always pull from the same filename.

Would that work in your situation?

Regards,
Ron

That is definitely a solution. The problem is the txt file is created via
some vendor's software and not sure if it can be set up to write the files
like this. I will check it out. Thanks.

Nathan

"Ron Coderre" wrote:

If your text file is automatically generated by a scheduled export from a
database, (in my case, overnight processing of GL, etc) I have the IT group
generate 2 text files. One with the date stamp to retain history and a
second with a Non-Changing file name, like: GLDOWNLOAD.TXT (overwriting the
file if necessary). That way, no special programming is necessary and links
always pull from the same filename.

Would that work in your situation?

Regards,
Ron