How to use Name statement in VBA?

The Name statement in VBA (Visual Basic for Applications) is used to rename a file or move a file from one directory to another. It’s a straightforward yet powerful way to manage files within your VBA projects.


Name oldPath As newPath
  • oldPath: The current name and location of the file. This must include the full path if the file is not in the current directory.
  • newPath: The new name and/or location for the file. This also must include the full path if the file is not in the current directory.

How to Use

Renaming a File

To rename a file, you provide the current file path and name, and the new name you want for the file.

Name "C:\MyFolder\OldFileName.txt" As "C:\MyFolder\NewFileName.txt"

This will rename “OldFileName.txt” to “NewFileName.txt” in the “MyFolder” directory.

Moving a File

You can also use the Name statement to move a file from one directory to another.

Name "C:\MyFolder\MyFile.txt" As "C:\AnotherFolder\MyFile.txt"

This moves “MyFile.txt” from “MyFolder” to “AnotherFolder”.

Error Handling

It’s important to include error handling, as attempting to rename or move a file that does not exist, or if there are permission issues, will result in a runtime error.

On Error Resume Next
Name "C:\MyFolder\OldFileName.txt" As "C:\MyFolder\NewFileName.txt"
If Err.Number <> 0 Then
    MsgBox "Error in renaming/moving file: " & Err.Description
End If
On Error GoTo 0

Important Considerations

  • File Existence: The file specified by oldPath must exist, or an error will occur.
  • File Overwriting: If a file with the name specified by newPath already exists, an error will occur. VBA’s Name statement does not overwrite existing files.
  • Permissions: The user running the VBA script must have adequate permissions to rename or move the file.
  • Open Files: If the file is open in another application, an error will occur. Ensure the file is closed before attempting to rename or move it.
  • File Extension Change: Be cautious when changing file extensions, as this might render the file unusable or unrecognizable by other applications.

The Name statement is a valuable tool in file management within VBA, offering a simple method to rename or reorganize files in your projects and applications.

Unlock Your Potential


Basic - Advanced


Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project

Leave a Reply

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