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

[@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.

[@RS-we7lx]

Thank you! Thank you!

[@deepamanmappy]

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

[@احمد-ه1ق3ب]

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

[@ExcelDestination]

Will upload soon

[@احمد-ه1ق3ب]

@@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?

[@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?

[@gilekk]

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

[@senndarkheart6143]

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?

[@pratipbanerjee68]

Good job

[@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!

[@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!

[@ExcelMadeEasy444]

Sir I Like It Very much !!!

[@silverlicious2086]

Very helpful. Thank you.

[@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]

[@postmallf7921]

sir where i download the above code

[@MohAboAbdo]

Thank You So Mutch, Sir.

[@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?

[@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

[@shadow_gaming_sk]

Excellent , how to break links in vba code

[@anil11996]

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

[@098silvio]

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

[@yangdkny3476]

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

[@aawwyeahh8954]

do you have sample file for code?

[@vijaysahal4556]

good 👍👍👍

[@ExcelDestination]

Thank you 👍

[@KC_47.]

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

[@ExcelDestination]

Will try

[@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

[@nyarach]

Wow!!!

[@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

[@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

[@aminpinjari4070]

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

[@johnsapplications]

meh - doesn't copy validation