How To Split Excel Sheets Into Separate Files | Session 6
This video will show you how to separate excel sheets into separate files.
Below VBA code can help to split multiple sheets of excel workbook to separate Excel files in very quick time :
1. Copy your file in a new folder which you want to split, because the split Excel files will be created at the same folder as this master file.
2. Press ALT + F11 keys on key board, and it opens the Microsoft Visual Basic Applications window.
3. Click Insert tab and select Module, paste the below mentioned code in the Module Window.
4. Press F5 key to run the commend, and the file is splited into separate Excel files in the same folder along with the original master file.
Note: Name of Main master file and names of sheets has to be always different otherwise this command will not work.
VBA Code :
Sub Splitbook()
'UpdatedbyTechtoday
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
xWs.Copy
Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
Видео How To Split Excel Sheets Into Separate Files | Session 6 канала Tech Today
Below VBA code can help to split multiple sheets of excel workbook to separate Excel files in very quick time :
1. Copy your file in a new folder which you want to split, because the split Excel files will be created at the same folder as this master file.
2. Press ALT + F11 keys on key board, and it opens the Microsoft Visual Basic Applications window.
3. Click Insert tab and select Module, paste the below mentioned code in the Module Window.
4. Press F5 key to run the commend, and the file is splited into separate Excel files in the same folder along with the original master file.
Note: Name of Main master file and names of sheets has to be always different otherwise this command will not work.
VBA Code :
Sub Splitbook()
'UpdatedbyTechtoday
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
xWs.Copy
Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
Видео How To Split Excel Sheets Into Separate Files | Session 6 канала Tech Today
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Split Each Excel Sheet Into a Separate File](https://i.ytimg.com/vi/zcUYP_ZjhWw/default.jpg)
![](https://i.ytimg.com/vi/RIR_8DdLfxc/default.jpg)
![Consolidate & Clean Multiple Excel Sheets in One Pivot Table](https://i.ytimg.com/vi/FI4HkCzMaIk/default.jpg)
![Split Data into Multiple Sheets in Excel with this Hidden Trick | Vivekananda Sinha | Video 67](https://i.ytimg.com/vi/VjoVKIa6HLI/default.jpg)
![Excel Split Names Tutorial](https://i.ytimg.com/vi/yCxnWvD_r_Q/default.jpg)
![Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner](https://i.ytimg.com/vi/5bOFNsdHiPk/default.jpg)
![VBA: Split data into Separate Workbooks](https://i.ytimg.com/vi/48oUxaL7X6c/default.jpg)
![3 Methods to Unhide All Sheets in Excel (& how to hide)](https://i.ytimg.com/vi/hJsF8dK745Y/default.jpg)
![We Built Our Cozy Off Grid Cabin for $7,000](https://i.ytimg.com/vi/4Enrm07f0QM/default.jpg)
![How to split an Excel workbook into multiple files](https://i.ytimg.com/vi/vfMnD3_UgSw/default.jpg)
![How to Split Each Excel Sheet into Separate Files Easy (Excel 2003-2016)](https://i.ytimg.com/vi/tt71SL2hmhM/default.jpg)
![Google Sheets - Split Data into Separate Tabs (Sheets)](https://i.ytimg.com/vi/4_9uAMsqz5o/default.jpg)
![Transfer Data From One Sheet to Multiple Sheets Automatically in excel (Hindi) | Without Macro](https://i.ytimg.com/vi/BgSkUpqBun0/default.jpg)
![How to Split Data Into Multiple Workbooks by Excel VBA](https://i.ytimg.com/vi/vCDKFn0fCkk/default.jpg)
![Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)](https://i.ytimg.com/vi/fHFUh6EhBcw/default.jpg)
![Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)](https://i.ytimg.com/vi/bxsvO6_uJUs/default.jpg)
![Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 1](https://i.ytimg.com/vi/_jegiQkyC3s/default.jpg)
![How To Copy An Excel Range To Outlook Using VBA](https://i.ytimg.com/vi/9bhypq36xes/default.jpg)
![6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Included](https://i.ytimg.com/vi/Lh0vvEhw4Tk/default.jpg)
![Split Excel Workbook Into Multiple Sheets in 30 Seconds](https://i.ytimg.com/vi/Y0OYAaAtZ00/default.jpg)