/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
103 |
Delete single or range of sheet(s). |
/1 = sSheet Start (by name or by number) /2 = sSheetEnd (by name or by number) /3 = sSheetDeleteAllExceptThisOne (by name or by number) |
This special process can delete one or several entire worksheets.
Special Parameters Described in Detail
/1{sSheetStart} Used to either specify the deletion of a single sheet, or the beginning of a range of sheets to delete. Note: the range is inclusive, meaning sSheetStart is deleted.
/2{sSheetEnd} Used to specify the end of a range of sheets to delete. Note: the range is inclusive, meaning sSheetEnd is deleted.
/3{sSheetDeleteAllExceptThisone} Used to specify the only sheet to remain in the workbook. All other sheets will be deleted. If this parameter is not specified then /1{sSheetStart} must be.
Additional Notes: You can use this special process to delete sheets from a single workbook file, or a whole folder (and subfolders) of workbooks. There must be at least one sheet in a workbook left. In other words, you cannot delete all the sheets in a workbook.
Examples:
EXAMPLE 1: Delete a single sheet from a workbook
EXAMPLE 2: Delete a range of sheets from workbook
EXAMPLE 3: Delete all sheets in a workbook, except for the one specified