/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
104 |
Add new sheet to workbook at specified location. |
/1 = sSheetToAdd (by name) /2 = sSheetBefore (by name or by number) /3 = sSheetAfter (by name or by number) /4 = bOverwriteExisting ("TRUE" or "FALSE") |
This special process can add new worksheets to one or many workbooks.
Special Parameters Described in Detail
/1{sSheetToAdd} Name of the sheet to add. Not required.
/2{sSheetBefore} Added sheet will be placed before this sheet (Name or #). If sSheetBefore = "firstfirst" then it is placed as the first sheet in the workbook.
/3{sSheetAfter} Added sheet will be placed after this sheet (Name or #). If sSheetAfter = "lastlast" then it is placed as the last sheet
/4{bOverwriteExisting} If sSheetToAdd already exists, it will be overwritten with an new, empty worksheet if this parameter is set to "TRUE". If sSheetToAdd already exists nothing will be done if this parameter is set to "FALSE".
Additional Notes: Only sSheetBefore, or sSheetAfter should be specified, not both. If neither the sSheetBefore, nor the sSheetAfter have been specified then the new sheet will be the last sheet.
Examples:
EXAMPLE 1: Add a new sheet to a workbook
EXAMPLE 2: Add a new sheet to a workbook, before a specified sheet
EXAMPLE 3: Add a new sheet to many workbooks, specify it as the 1st sheet