VBA to Save Each Worksheet as New Workbook - VBA Save as new excel file

This Excel VBA Tutorial explains VBA Code to save multiple sheets as new individual Excel File. VBA code will loop through each sheet and create new file and save to a specific location.

[gugusworld]

Hi Sir,
Thanks for your hard work. I have tried this method and it’s working absolutely fine. Thank you so much for your support.

[احمد-هقب]

Thank you
I am looking forward for more videos about VBA excel

[deepamanmappy]

Thanks a lot for your precious time to post this wonderful video

[ediokt]

Dear sir, your code really clean and easy to understand but i need to save on same location where the active workbook open. Is it possible?

[senndarkheart]

Hi Sir, thanks for the video,
if you are still active, could you tell me if it is possible to skip multiple sheets? as your example states it skip one sheet, but what if you have another sheet named "instructions" as example, how to skip it as well?
Do you set For = i 2 to A? (didnt work for me) or will you need to work with aray?

[gilekk]

Thanks so much for this. What if we just need to export a single sheet?

[freddylai]

Thank you your video tutorial! Quite helpful!
Indeed if it is possible to use VBA coding to instruct:
1) create a folder which is not existing from the location path,
2) the new folder name based on a specific cell value.
Thank you for your great help!

[Jamitjamming]

how to customized the saving location if others would use the macro in their own PC or laptop? thank you

[bobsanville]

Thank you for the video! If I only wanted to copy a range of the Sheets, example A1: G30 instead of the whole sheet, where would I enter the code? Thanks!

[Jamitjamming]

how to code the saving location if it would be a shared file so that others can use the macro in their own PC or laptop? thank you

[sapanaratanpara]

First of all this video is very helpful. This is very close to what I am trying to do. I am running into the error when try to use this code on line ‘wb.SaveAs.... ‘ it says Syntax error and I can’t figure it out.. any thoughts or suggestions?

[silvio]

Hello, can you help me please. I need to Export the 7 of 20 worksheets as a separate files, not as one.

[anil]

Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders

[wit]

thanks for the tutorial,
but there is one thing i want to ask?
what if we only choose the sheet to be made into a separate workbook?

[ABJK-dswq]

Can you make a code to split a master sheet into multiple sheets? For example, I have sales data by month for one year. I want data split by month in separate worksheets. Thank you!

This video is great too.

[yangdkny]

if i need export column a to c all new excel file what code i should be add

[madhun]

I want my cells in new worksheet as paste special.. where do we need to update the formula?

[shadow_gaming_sk]

Excellent, how to break links in vba code

[hemantgoyal]

Sir if the sheet already exists there then how to replace and save that sheet

[KC_.]

Sir, can u show how to make customize (not always in same area) print area by using VBA?