Origin has a tool for splitting workbooks into new, single-sheet workbooks. You can split the active workbook; all workbooks in the active (Project Explorer) folder; all workbooks in the active folder and subfolders; all open workbooks in the active folder; or all workbooks in the project. All new workbooks are added to the main project folder. The wsplit_book dialog box uses the wsplit_book X-Function.
To open this dialog box:
All in Active Folder
All in Active Folder (Recursive)
All in Active Folder (Open)
All in Project
Keep the source workbook intact. Otherwise the source workbook is deleted.
Use the worksheet Short Name for the new book Short Name. Special characters and spaces are stripped out.
Key String Search at
Key String (like:"?ook*")