Sep 21, 2018

How to split a workbook to separate Excel files with saving each worksheet of the workbook as an individual Excel file

VBA code to split multiple worksheets of current workbook to separate Excel files

Note:  the split Excel files will be stayed at the same folder as this master workbook.
1. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA: Split a workbook into multiple workbooks and save in the same folder.

3. Press the F5 key to run this code. And the workbook is split to separate Excel files in the same folder with the original workbook.