File object
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
- Objects (Visual Basic for Applications)
- Object library reference for Office (members, properties, methods)
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.