Split Sheets Into Workbooks Excel VBA Macro

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[razamoulvi]

Great Code sir.👌🏻👌🏻
So comfortable and easy to use..
Thanks for the code

[omarwameedh]

second like from my side 😊 keep uploading such videos

[PappaG]

Excellent code, simple and effective.
Q - is it possible to exclude certain sheets from copying rather than copying all sheets?

[rldb]

Can u please explain how to export only the selected sheets instead of all the sheets? TIA

[juliamacha]

Hey, do you know how to pull out only columns with specific names (for example only model columns) form each worksheet into separate workbooks?

[dominicowusu]

Thank you for the video.
I keep getting Run-Time error 1004:
copy method of worksheet class failed.

I have opened my active workbook only.
What could be the cause and solution?

[manukv]

Done ..but one sheet is showing error code 1004.... Can u pls advise, 🤔

[Mukherjee_Tamal]

Sir, not able to use this code once I am saving this in module under personal macro workbook and apply for other open workbook. Any solution to this?

[manukv]

U r we want to save to specific folder .... Pls show the code

[abhilashsharma]

Sir where to give path of network where files are saved?