XLS Object

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