Create a separate file for each worksheet | how to split each excel sheet into separate files

hi i am manoj kumar
IN THIS VIDEO WE ARE GOING TO LEARN ABOUT how to split each excel sheet into separate files by VBA
VBA CODE
*******CODE**********
Sub Split_excel_sheets()
Dim ipath As String
ipath = Application.ActiveWorkbook.Path
Application.DisplayAlerts = False
For Each ws In ThisWorkbook.Sheets
ws.Copy
Application.ActiveWorkbook.SaveAs Filename:=ipath & "\" & ws.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
End Sub
************************************************************************************
worksheets
convert each excel worksheet into separate excel file
split each sheet into separate file
create a copy worksheet copy
how to split each excel sheet into separate files
worksheet to file
all excel sheet convert to separate file workbook
make separate file of every sheet
how to split excel sheet to separate file
how to separate sheet to file
how to create a pivottable from two separate excel workbooks
how to create a pivottable from two separate data sources
BY‪@manojkumarexcel‬
FROM
BHORHA
SIMRI BAKHTIYARPUR
SAHARSA
BIHAR
INDIA

[@aaishaeducation]

Very nice sir 👌👌👌 like 👍👍
V useful video 💖💖💖💖💖💖

[@ovejerof]

Buen video 👌🏻👌🏻👌🏻

[@LearningCampaign]

Superb

[@SmitaPatra-or6eu]

Sir why xlsm sheet isn't created

[@SmitaPatra-or6eu]

Please provide the solution asap

[@SmitaPatra-or6eu]

Sir this process is not working

[@yassergames8023]

السلام عليكم ورحمه الله

[@sadashivapppp9066]

Sir only one sheet is getting saved please help

[@manojkumarexcel]

Save as macro enable

[@vikashkumar-vd9ku]

Take time lote...

[@charan0508]

Error in ws.copy

[@manojkumarexcel]

[e-mail]