0

I am setting up a system where we are scanning a single page to PDF and saving it to a specific folder.

I want to build an Excel spreadsheet that looks at the Date Modified property of the saved files in this particular folder and build my system based on when these files were saved.

I am not sure how to access this Date Modified property.

Community
  • 1
  • 1
Josh
  • 265
  • 6
  • 11
  • 20

1 Answers1

1

You can access properties of a file using the Microsoft scripting runtime FileSystemObject class, including the date a file was last modified as shown below:

Sub GetDateCreated()

    Dim fileSysObj As Object: Set fileSysObj = CreateObject("Scripting.FileSystemObject")
    Debug.Print fileSysObj.GetFile("C:\myFile.txt").DateLastModified
    Set fileSysObj = Nothing

End Sub
Francis Dean
  • 2,386
  • 2
  • 22
  • 29