Uncategorized

How I can separate all pages from an Excel Sheet with VBA Code .

11/12/2021
Md.Hasan Mahmud Tuhin
Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

The following VBA code can help you quickly split multiple worksheets of current workbook to separate Excel files, please do as follows:

1. Create a new folder for the workbook that you want to split, because the split Excel files will be stayed at the same folder as this master workbook.

2. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

3. 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

Type the code which code attached the word file .

VBA-Code-excel-file-seperate-Download

4. 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. See screenshot:

Note: If one of the sheets has the same name with the workbook, this VBA cannot work.

16 thoughts on “How I can separate all pages from an Excel Sheet with VBA Code .”

Leave a Reply

Your email address will not be published. Required fields are marked *

Get 30% off your first purchase

Got it!
X
error: Content is protected !!