Returns the date and time that the specified file or folder was last modified. Read-only.
Syntax
object.DateLastModified
The object is always a File or Folder object.
Examples
The following code illustrates the use of the DateLastModified property with a file.
Function ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(filespec) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
Debug.Print s
End Function
Run this code in Immediate Window:
Debug.Print ShowFileAccessInfo("D:\helloworld.txt")
Result:
D:\HELLOWORLD.TXT
Created: 2022/4/14 9:36:47
Last Accessed: 2022/4/14 9:36:47
Last Modified: 2022/4/14 14:16:17