File Object

Last modified: December 06, 2011

Applies to: Office 2013 | VBA


Provides access to all the properties of a file.


The following code illustrates how to obtain a File object and how to view one of its properties.

Sub ShowFileInfo(filespec)
    Dim fs, f, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set f = fs.GetFile(filespec)
    s = f.DateCreated
    MsgBox s
End Sub

© 2014 Microsoft