VBA Rename Folder or Directory | Explained with Examples

VBA Rename folder helps to change existing folder name to specified new name of folder. We use ‘Name’ function in VBA to rename a folder. We have to specify old name and new name of folder. In the following tutorial we have explained step by step instructions to run example macro.

Read more details about VBA Name function : VBA Name Function

Table of Contents:

Objective
VBA Rename a Folder or Directory
Instructions to Run VBA Macro Code
Other Useful Resources

VBA Rename a Folder or Directory

Let us see an example macro VBA code to rename a folder or directory. We use VBA Name function to change or rename folder name or directory name. In the below example we are specifying the old name and new name of folder or directory. You can change this path according to your requirement. If specified folder path is not available, it throws an error. To avoid error message, we are checking whether specified folder is exists or not using Dir function. If it is not available, it displays message. You can see the sample screenshot at the end of the macro.

'VBA Rename a Folder
Sub VBAF1_Rename_Folder()
    
    'Variable declaration
    Dim sFolder_OldName As String
    Dim sFolder_NewName As String
    
    'Existing Folder Name
    sFolder_OldName = "C:\VBAF1\Sample\"
    
    'Define New Name of folder to change
    sFolder_NewName = "C:\VBAF1\Test\"
    
    'Check Specified folder exists or not
     If Dir(sFolder_OldName) <> "" Then
        'Rename Folder using Name function
        Name sFolder_OldName As sFolder_NewName
        MsgBox "Folder has renamed.", vbInformation, "VBAF1"
    Else
        MsgBox "Folder is not available to rename.", vbInformation, "VBAF1"
    End If
        
End Sub

Output: You can find following screenshot of above macro output for your reference.