Visual Basic for Applications Reference
Returns the date and time that the specified file or folder was last accessed. Read-only.
The object is always a File or Folder object.
The following code illustrates the use of the DateLastAccessed property with a file:
Sub 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 MsgBox s, 0, "File Access Info" End Sub
Important This method depends on the underlying operating system for its behavior. If the operating system does not support providing time information, none will be returned.