To find the latest file

[mrajeshtnl]

How can we write a script to find a latest file in a folder

Thanks

[inborntester]

Based on modified date of files we can get, means the file one having latest modified date is the latest file.

Code:

Set FSO = CreateObject("Scripting.FileSystemObject")
Set Folder = FSO.GetFolder("D:\test")
LatestModifiedFileDate = #1/1/0001#
For Each File In Folder.Files
    If  File.DateLastModified > LatestModifiedFileDate Then
        LatestModilfiedFile= File.Name
        LatestModifiedFileDate = File.DateLastModified
    End If
Next
msgbox (LatestModilfiedFile)