Rename an Excel worksheet in another workbook

How to rename a single Excel worksheet in another open or closed workbook using VBA

METHOD 1. Rename an Excel worksheet in another open workbook using VBA

VBA

Sub Rename_Worksheet_in_Another_Open_Workbook()
'declare variables
Dim wb As Workbook
Dim ws As Worksheet
Set wb = Workbooks("Exceldome.xlsx")
'activate a workbook
wb.Activate
Set ws = Worksheets("Sheet2")
'rename the worksheet in the workbook specified above
ws.Name = "Data"

End Sub

OBJECTS
Workbooks: The Workbooks object represents all of the open Excel workbooks.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Workbook Name: Have an open workbook named Exceldome.xlsx.
Worksheet Name: Have a worksheet named Sheet2 in the Exceldome.xlsx workbook.

ADJUSTABLE PARAMETERS
Worksheet to Rename: Select the worksheet that you want to rename by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.
Rename Worksheet: Rename a worksheet to any name, within Excel limits, by changing the Data worksheet name in the VBA code.
Workbook Selection: Select the workbook where you want to rename a worksheet by changing the Exceldome.xlsx workbook name to any open workbook.

METHOD 2. Rename an Excel worksheet in another closed workbook using VBA

VBA

Sub Rename_Worksheet_in_Another_Closed_Workbook()
'declare variables
Dim wb As Workbook
Dim ws As Worksheet
Set wb = Workbooks.Open("C:\Excel\Examples.xlsx")
'open and activate a workbook
wb.Activate
Set ws = Worksheets("Sheet2")
'rename the worksheet in the workbook specified above
ws.Name = "Data"

End Sub

OBJECTS
Workbook: The Workbooks object represents all of the open Excel workbooks.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Workbook Location: Have the workbook that you are referencing to in the VBA code located on your device in the C:\Excel\ path.
Workbook Name: Have a closed workbook named Exceldome.xlsx, in the location specified in the VBA code.
Worksheet Name: Have a worksheet named Sheet2 in the Exceldome.xlsx workbook.

ADJUSTABLE PARAMETERS
Worksheet Location: Select the location of the workbook where you want to change the name of a worksheet by changing the C:\Excel\ path.
Workbook Selection: Select the workbook in which you want to rename a worksheet by changing the Exceldome.xlsx workbook name to any closed workbook that is located in the path provided in the VBA code.
Worksheet to Rename: Select the worksheet that you want to rename by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.
Rename Worksheet: Rename a worksheet to any name, within Excel limits, by changing the Data worksheet name in the VBA code.

Explanation about how to rename a worksheet in another workbook

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to rename a single worksheet in another workbook using VBA.

VBA Methods: Using VBA you can rename a worksheet in another open or closed workbook by referencing to a specific workbook. For workbooks that are closed, the VBA code must initially open the workbook and then rename the specified worksheet.