wsplit_book

Contents

1 Menu Information
2 Brief Information
3 Command Line Usage
4 Variables
5 Description

Menu Information

Split Workbooks

Brief Information

Split specific workbooks into multiple workbooks with single sheet

Command Line Usage

wsplit_book 1; // split all workbook in active folder

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Split	fld	Input int	active	Specify what workbooks are to be split Option list: active:Active Book Split the active workbook folder:All in Active Folder Split all workbooks in the active folder recursive:All in Active Folder (Recursive) Split all workbooks in the active folder recursively open:All in Active Folder (Open) Split all opened workbooks in the active folder project:All in Project Split all workbooks in the project
Split Mode	mode	Input int	duplicate	Specify the split mode Option list: duplicate:Duplicate Create duplicated worksheets from the workbook drag:Drag Drag worksheets out of the workbook
Keep Source Workbook	keep	Input int	1	Whether keep source workbook after split
Rename Book Name with Sheet Name	rename	Input int	1	Whether rename the new book name using the sheet name extracted
Key String Search at	match	Input int	none	Where to search the key string Option list: none:NONE Do not search key string wkblong:Workbook Long Name Search the long name of workbooks wkbshort:Workbook Short Name Search the short name of workbooks comments:Workbook Comments Search the comments of workbooks
Key String(like:"?ook*")	key	Input string	<unassigned>	Specify the key string used in searching

Description

Split specific workbooks into multiple workbooks with single sheet