Insert Date Modified

[craigwojo]

Looking to add the date into cell "C4" from the Date Modified listed in the explorer

Thank you and God bless,
Craig

 

[Micron]

If you can use vba code, try the following

DateLastModified property (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

Fairly certain that (filespec) needs to be the path to a file as in
"C:\Users\Micron\Documents\Excel\myFileNameHere.xls"

In order to get info into a cell, you'd need to change Sub and End Sub to Function and End Function and place that function into a standard module.
You'd enter =ShowFileAccessInfo("C:\Users\Micron\Documents\Excel\myFileNameHere.xls") in a cell and then Enter to run it. Make sure you use your own file path and not what I posted.

 

[Micron]

I just noticed that the code is not proper for returning a value to the cell. More like this (including the change to a function and only returning what I think you asked for).

Function ShowFileAccessInfo(filespec)
    Dim fs, f, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set f = fs.GetFile(filespec)
    s = "Last Modified: " & f.DateLastModified
    'MsgBox s, 0, "File Access Info"
    ShowFileAccessInfo = s
End Function