RenameWorkSheet

Syntax

XLS.RenameWorkSheet [shName], NewShName

Description

Renames a worksheet in the active workbook.

Parameter	Description
shName	String, optional. The name of the worksheet to be renamed. If omitted or contains a zero-length string, the active worksheet will be renamed.
NewShName	String, required. The new name for the selected worksheet.

See Also

MoveWorkSheet

Example

Sub Main
 
Dim mySheets() As String
Dim x As Integer
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   XLS.AddWorkBook
   XLS.AddWorkSheet "Test1"
   XLS.AddWorkSheet "Test2"
   XLS.AddWorkSheet "Test3"
   XLS.AddWorkSheet "Test4"
 
   XLS.RenameWorkSheet "Test2", "Hernoemd2"
 
   XLS.AppClose
 
End Sub