Provides access to all the properties of a file.
Examples
The following code illustrates how to obtain a File object and how to view one of its properties.
Function ShowFileInfo(filespec)
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(filespec)
ShowFileInfo = "Created: " & f.DateCreated
End FunctionRun this code in Immediate Window:
Debug.Print ShowFileInfo("D:\helloworld.txt")Result:
Created: 2022/4/14 9:36:47Collections
| 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. |