This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Variant (Date) that indicates the date and time when a file was created or last modified.
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".