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.
@ediokt99
3 жыл бұрын
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?
@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?
@gilekk
2 жыл бұрын
Thanks so much for this. What if we just need to export a single sheet?
@bobsanville6879
3 жыл бұрын
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!
@sapanaratanpara7439
3 жыл бұрын
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
3 жыл бұрын
you can share your code at exceldestination@gmail.com
@deepamanmappy
4 жыл бұрын
Thanks a lot for your precious time to post this wonderful video
@freddylai2008
2 жыл бұрын
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!
@احمد-ه1ق3ب
4 жыл бұрын
Thank you I am looking forward for more videos about VBA excel
@ExcelDestination
4 жыл бұрын
Will upload soon
@احمد-ه1ق3ب
4 жыл бұрын
@@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?
@postmallf7921
3 жыл бұрын
sir where i download the above code
@wit6518
3 жыл бұрын
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?
@098silvio
3 жыл бұрын
Hello, can you help me please. I need to Export the 7 of 20 worksheets as a separate files, not as one.
@anil11996
3 жыл бұрын
Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders
@RS-we7lx
Жыл бұрын
Thank you! Thank you!
@yangdkny3476
Жыл бұрын
if i need export column a to c all new excel file what code i should be add
@madhun8092
3 жыл бұрын
I want my cells in new worksheet as paste special.. where do we need to update the formula?
@ABJK-ds4wq
4 жыл бұрын
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
3 жыл бұрын
Contact me I can do this for you but I will charge for this. thanks
@pratipbanerjee68
4 ай бұрын
Good job
@hemantgoyal409
2 жыл бұрын
Sir if the sheet already exists there then how to replace and save that sheet
@shadow_gaming_sk
Жыл бұрын
Excellent , how to break links in vba code
@aawwyeahh8954
4 жыл бұрын
do you have sample file for code?
@KC_47.
4 жыл бұрын
Sir, can u show how to make customize (not always in same area) print area by using VBA?
@ExcelDestination
4 жыл бұрын
Will try
@ExcelMadeEasy444
4 жыл бұрын
Sir I Like It Very much !!!
@silverlicious2086
4 жыл бұрын
Very helpful. Thank you.
@KC_47.
4 жыл бұрын
I hope u can make video in 480p quality..
@ExcelDestination
4 жыл бұрын
while watching any tutorial, you can change the quality at your end. pls try that
@MohAboAbdo
4 жыл бұрын
Thank You So Mutch, Sir.
@sankarmondal89
3 жыл бұрын
How to save a file with a specific sheets. In a single workbook.
@Louieinoz
3 жыл бұрын
I'm after the same thing. I just want to save one specific sheet
@vijaysahal4556
4 жыл бұрын
good 👍👍👍
@ExcelDestination
4 жыл бұрын
Thank you 👍
@aminpinjari4070
Жыл бұрын
Each separate sheet should be saved according to the year of the student's name in the excel sheet
Пікірлер: 39