How to get Excel to open text files by the time created not name
I have a macro that is opening a number of *.txt files. I need the macro to
open the files in the order in which they were created (by date and time).
By default it looks as though Excel is opening them by extension/name.
Anybody know how to specify this?
|