How to Rename a File in Excel VBA?

In this post, you’ll learn how to rename a File in Excel VBA using Name command.

Rename a File in Excel VBA

In Excel VBA, to rename an existing file, you can use the Name Command.

To rename a file using Name command,

  • Firstly you need to locate the file in the local directory.
  • Copy the location address of the file.
How to Rename a File in Excel VBA?

“C:\Excel VBA\Excel VBA 2.xlsx”

Enter the following code in the Visual Basics editor,

Code:

Name "C:\Excel VBA\Excel VBA 2.xlsx" As "C:\Excel VBA\Renamed File.xlsx"
  • Run the codes.
  • Now go to the directory, you can see the file name changed. 
How to Rename a File in Excel VBA?