Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a folder with an ever expanding number of files named as follows
oldOrders001.xls oldOrders002.xls oldOrders003.xls oldOrders004.xls oldOrders005.xls ~ oldOrders095.xls etc........ will the following piece of code always find the very last alphabetically listed file, I only have win98 to test it on and am curious to know what will happen on other platforms such as XP With Application.FileSearch .LookIn = "C:\shopmain\orders\done" .SearchSubFolders = False .FileName = "oldOrders*.xls" .Execute lastFile = .FoundFiles(.FoundFiles.Count) End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
try to open excel files from explorer, 'file not found' | Excel Discussion (Misc queries) | |||
Linking files "File Not Found" | Excel Discussion (Misc queries) | |||
Filesearch : .zip files not found ??? | Excel Programming | |||
Multiple personal.xls files found! | Excel Programming | |||
Creating a list of found files | Excel Programming |