VBA allows you to rename an existing file, using the Name command. In this tutorial, you will learn how to rename a specific file.
If you want to learn how to copy and rename a file, you can click on this link: VBA Copy File
Rename a File in VBA
We will show how to rename the existing file Sample file 1.xlsx in the folder VBA Folder. The folder with the file now looks like in Image 1:
Image 1. File in folder C:\VBA Folder
Here is the code which will rename the file:
Name "C:\VBA Folder\Sample file 1.xlsx" As "C:\VBA Folder\Sample file 2.xlsx"
After running the code, the file Sample file 1.xlsx is now renamed to Sample file 2.xlsx. The output is in Image 2:
Image 2. Renamed file in the folder C:\VBA Folder
VBA Coding Made EasyStop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!