File Object

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.


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