VB Macro to get date last accessed of a file

[mchong71]

So I have a file name in column A the file path in B and I want to show the date the file was last accessed in C.

I found a script here on the interent but have not worked to much in depth with scripts. How would you go about coding a macro to do this.

Greatly appreciated

Matt

 

[CharlesChuckieCharles]

Date last accessed ??
Date created or date modified maybe, date last looked at is not recorded on the file

 

[mchong71]

Under the properties of the file there's created, modified, and accessed.

 

[Jon von der Heyden]

You can with FSO:

Public Sub Test()
    Dim fso As Object
    Dim strFile As String
    
    strFile = "C:\...." 'enter file path and name here
    
    Set fso = CreateObject("Scripting.FileSystemObject")
    Debug.Print fso.GetFile(strFile).DateLastAccessed
End Sub

 

[CharlesChuckieCharles]

Apologies You are quite correct never used it