work backwards through files in Folders object

[jender624]

Hi all,

There is a folder on our network drive that I'm reading into a Folders object (through the use of a FileSystemObject). There are 5000 files in the folder, and I'm only looking for the latest set of them based on the date created/modified property of the file, which is how the folder will always be sorted (ascending). Thus, the set of files I'm looking for are always at the end of the list.

Instead of looping through all files in the folder to get what I want (currently takes 5 or so minutes), is there a way of working backwards from the end of the file list to the beginning, so I can stop when I've got what I want? This would eliminate the pain of waiting............................

Thanks!

jender624

 

[TCARPENTER]

Set Files = Folder.Files
For lngCnt = Files.Count to 0
Files(lngCnt)...
Next lngCnt

 

[Craig0201]

Set Files = Folder.Files
For lngCnt = Files.Count to 0 Step -1
Files(lngCnt)...
Next lngCnt

to be precise.