Sets or returns the name of a specified file or folder. Read/write.
Syntax
object.Name [ = newname ]
The Name property has these parts:
Part | Description |
---|---|
object | Required. Always the name of a File or Folder object. |
newname | Optional. If provided, newname is the new name of the specified object. |
Examples
The following code illustrates the use of the Name property.
Function ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = f.Name & " on Drive " & UCase(f.Drive) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
Debug.Print s
End Function
Run this code in Immediate Window:
Debug.Print ShowFileAccessInfo("D:\helloworld.txt")
Result:
helloworld.txt on Drive D:
Created: 2022/4/22 17:06:06
Last Accessed: 2022/4/22 17:06:06
Last Modified: 2022/4/22 17:06:06