Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scripting.FileSystemObject | Excel Discussion (Misc queries) | |||
Scripting.FileSystemObject LAN | Excel Programming | |||
Creating FileSystemObject | Excel Programming | |||
Help with FileSystemObject? | Excel Programming | |||
FileSystemObject to get last 10 lines of text file. | Excel Programming |