FILEDATETIME

FILEDATETIME(pathname)

Returns the date and time when a file was created or last modified (Date).

pathname

The full pathname of the file you want to examine (String).

REMARKS

* The "pathname" may include a directory and drive.
* If "pathname" is not a valid file path, then you will get a run time error.
* You can use the FILEATTR function to return the file mode of an open file.
* You can use the FILELEN function to return the length of a file in bytes.
* You can use the GETATTR function to return the attributes of a file or directory.
* The equivalent .NET function is [[Microsoft.VisualBasic.FileSystem.FileDateTime]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print FileDateTime("C:\text.txt")    '= "21/11/22 14:08:23 PM"  

Dim sFolderPath As String 
sFolderPath = "C:\temp\myfile.xlsm" 
Debug.Print FileDateTime(sFolderPath)      '= "07/03/21 06:28:54 PM"