Is there a way in VB to sort files by the date modified?
I currently have a macro that searches a folder for .xls files with a certain name, but I would like to know if i can also sort by date modified so that the first file it finds is the latest modified.
any help is appreciated.
cheers
I currently have a macro that searches a folder for .xls files with a certain name, but I would like to know if i can also sort by date modified so that the first file it finds is the latest modified.
any help is appreciated.
cheers