import external data from changing file name

N

nathan

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
 
R

Ron Coderre

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
 
N

nathan

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
 
Top