MoveWorkSheet

Syntax

XLS.MoveWorkSheet [shName, ][shBefore, ][shAfter]

Description

Reorders a worksheet in the tabs of the active workbook.

This method uses the standard Excel Move instruction for worksheet. A move instructions can only be accomplished by defining before or after which worksheet the moving worksheet must be placed.

Note: Either shBefore or shAfter must be a value assigned to. When both parameters have values assigned to, shAfter is ignored.

Parameter	Description
shName	String, optional. The name of the worksheet being moved. If omitted or when an empty string, the active worksheet will be moved.
shBehore	String, optional. The name of the worksheet where the moving worksheet will move in front to.
shAfter	String, optional. The name of the worksheet where the moving worksheet wil move behind to.

WARNING: moving worksheets around in a Excel workbook can cause an inpredictable error, code 1004. This is due to restrictions in Excel and is NOT a Tradium error message.

See Also

RenameWorkSheet

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.SaveWorkBook , "o:\AdminSQL\Scripts\mijntest.xlsx"
 
   XLS.MoveWorkSheet , , "Test1"
 
   XLS.ListWorkSheets mySheets()
 
   For x = 1 To UBound(mySheets)
      Debug.Print mySheets(x)
   Next x
 
   XLS.AppClose
 
End Sub