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.

[@gugusworld2021]

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.

[@pratipbanerjee68]

Good job

[@RS-we7lx]

Thank you! Thank you!

[@deepamanmappy]

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

[@silverlicious2086]

Very helpful. Thank you.

[@bobsanville6879]

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!

[@ExcelMadeEasy444]

Sir I Like It Very much !!!

[@MohAboAbdo]

Thank You So Mutch, Sir.

[@user-ws8hq6uz6t]

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

[@ExcelDestination]

Will upload soon

[@user-ws8hq6uz6t]

@@ExcelDestination I have question if do not mind,
I have excel file name LPF and I want write VBA code that make a new folder every month and name the folder with LPF and date then the VBA code will save the LPF excel file as PDF and name it as LPF and today date in the same folder.
So how can I write the VBA code, please?

[@freddylai2008]

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!

[@gilekk]

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

[@ediokt99]

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?

[@098silvio]

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

[@wit6518]

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?

[@postmallf7921]

sir where i download the above code

[@sapanaratanpara7439]

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?

[@ExcelDestination]

you can share your code at [e-mail]

[@anil11996]

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

[@nyarach]

Wow!!!

[@aawwyeahh8954]

do you have sample file for code?

[@yangdkny3476]

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

[@madhun8092]

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

[@hemantgoyal409]

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

[@vijaysahal4556]

good 👍👍👍

[@ExcelDestination]

Thank you 👍

[@ABJK-ds4wq]

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.

[@MohdImran-rk1rh]

Contact me
I can do this for you but I will charge for this.
thanks

[@KC_47.]

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

[@ExcelDestination]

Will try

[@MrChinna143143]

Excellent , how to break links in vba code

[@KC_47.]

I hope u can make video in 480p quality..

[@ExcelDestination]

while watching any tutorial, you can change the quality at your end. pls try that

[@aminpinjari4070]

Each separate sheet should be saved according to the year of the student's name in the excel sheet

[@sankarmondal89]

How to save a file with a specific sheets. In a single workbook.

[@Louieinoz]

I'm after the same thing. I just want to save one specific sheet

[@johnsapplications]

meh - doesn't copy validation