Skip to main content

Name property

Table of contents
  1. Syntax
  2. Examples

Sets or returns the name of a specified file or folder. Read/write.


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.


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")


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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>