Edit

File object

  • Article

Provides access to all the properties of a file.

Remarks

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

Collections

Collection Description
Files Returns a collection of all the files in a specified folder.

Methods

Method Description
Copy Copies a specified file from one location to another.
Delete Deletes a specified file.
Move Moves a specified file from one location to another.
OpenAsTextStream Opens a specified file and returns a TextStream object to access the file.

Properties

Property Description
Attributes Sets or returns the attributes of a specified file.
DateCreated Returns the date and time when a specified file was created.
DateLastAccessed Returns the date and time when a specified file was last accessed.
DateLastModified Returns the date and time when a specified file was last modified.
Drive Returns the drive letter of the drive where a specified file or folder resides.
Name Sets or returns the name of a specified file.
ParentFolder Returns the folder object for the parent of the specified file.
Path Returns the path for a specified file.
ShortName Returns the short name of a specified file (the 8.3 naming convention).
ShortPath Returns the short path of a specified file (the 8.3 naming convention).
Size Returns the size, in bytes, of a specified file.
Type Returns the type of a specified file.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.