Using FileSystemObject to get File
This is probably not so much an Excel Programming question, but I'm
hoping someone can help me here.
I have a script that sends an Excel file by email each day. It has to
choose the most recent file from a given folder. The file names are
like this:
MyFile Jan 01.xls
MyFile Jan 02.xls
MyFile Jan 03.xls
etc..........
Is there a way to use FileSystemObject to get the file with the latest
date? I can't use the Format function in script, or otherwise this
would be easier.
tod
|