Last modified: December 06, 2011
Applies to: Office 2013 | VBA
Returns a Variant (Date) that indicates the date and time when a file was created or last modified.
FileDateTime( pathname )
This example uses the FileDateTime function to determine the date and time a file was created or last modified. The format of the date and time displayed is based on the locale settings of your system.
Dim MyStamp ' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM. ' Assume English/U.S. locale settings. MyStamp = FileDateTime("TESTFILE") ' Returns "2/12/93 4:35:47 PM".