• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

VBScript

Experts,

I need a vbscript that will return the file name of the latest date modified file within a folder.

For example 3 files in folder:

test1.xls          4/3/2011
test2.xls          4/1/2009
test3.xls          5/3/2001

I need it to return  test1.xls

Any ideas?

Thanks.
Dim objFSO, filename, strFiles, objFile
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set objSelectedFolder = objFSO.GetFolder("c:\temp\")

    Set colFiles = objSelectedFolder.Files
    For Each objFile In colFiles
        strFiles = objFile.name
      end if
    Next
filename =  strFiles

Open in new window

0
asmyatt
Asked:
asmyatt
1 Solution
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Hello, you can try this:

Set objFSO = CreateObject("Scripting.FileSystemObject")

SearchFolder = "c:\temp\"
Set objFolder = objFSO.GetFolder(SearchFolder)

NewestFile = ""
NewestDate = #1/1/1970#

For Each objFile In objFolder.Files
    If objFile.DateLastModified > NewestDate Then
        NewestDate = objFile.DateLastModified
        NewestFile = objFile.Name
    End If
Next

WScript.Echo NewestFile

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now