This might be difficult, at least it is for me.
I have a macro that opens a data source c:data1.txt and formats the data.
The problem is that everyday I have to rename the data source to data1.txt.
Is there a way the macro can open the newest data file?
I have a macro that opens a data source c:data1.txt and formats the data.
The problem is that everyday I have to rename the data source to data1.txt.
Is there a way the macro can open the newest data file?