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?

Perhaps you could show what code you are using to open them?

with no other information, populate an array with filenames and dates, then
search through the array and open the files by date.

--
Regards,
Tom Ogilvy


"khm6278" wrote:

> 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?