VBA CODE 👉
Download All Projects 👉
Buy Excel & Word Course 👉
.
Telegram Group 👉
My Instagram 👉
Facebook Group 👉
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Here in this article, I have explained How can we split each Excel Sheet into a Separate File by doing a single click.
Some of my subscribers were searching the solution to this problem, but they are unable to do this. He has a file where it has 100 Excel Sheet in a Single file, now he was asking that can we convert all the sheets and their data also in Single-Single file automatically, I said yes you can do it with an easy single click but we need a VBA code for automatically doing this task.
We can separate the sheet into single files manually also but it is very time taking work. if someone has 1000 Excel Sheets in a File and wanted to convert All 1000 Sheets into Single- Single file separately and do it manually then it will take almost 2 days to convert. So our purpose to is how to do this task within 1 or 2 minutes.
Here to Solve this problem we have used a VBA code which I have given below, you just copy & paste into your excel VBA application. Just Open your file then Press “ALT+F11” to open VBA Application by shortcut then Go to the Insert Tab then click on the “Module” button. Now Copy the below code and paste in the Module blank page.
Now finally you have to Run the code by pressing the F5 button or directly clicking in Run button on top of the menu.
and now you all sheets will start to convert in Single- Single file separately and automatically.
remember – Your all files will be saved where your big file is already saved. means the same path you have to check to find the exported files
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel Videos
🔹
(2) Tally Videos
🔹
(3) Sponsored Videos
🔹
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry
➟ nazim.khan09@gmail.com
➟ Website:
#Call_9536250020_to_Join_Advance_Excel_Course #TechGuruPlus #NazimKhan…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Thank You Bhai
From Kuwait❤❤
I want this data in different tabs, Could you please help me in this..?
Showing
Run-time error '1004':
We couldn't copy this sheet.
My data in excel sheet is date wise amd I want to print pages excel sheet,but date wise…means when date changes it comes to next page..help pls
super ,time saving sir, thank you sir
Sir ji good evening pls help me age se year kaisa count kare excel pe
Sir vba bata time usas use karna bata da
Thanks guru ji
Useful
Wonderful….! i always spend a lot of time in it. many thanks
VBN CODE : RUN-TIME ERROR 1004 AA RAHA HE SIR
Excellent trick
Housing society account maintain karne k liye koi software batao Nazim bhai
Sir, Mera Qtn. Power Query Se Related Hai. P.Q. Me Excel ke old versions I.e., 97-2003 ki files ko direct import kaise Karenge, Bina use .xlsx Me convert kare and bina use Table banaye?
Plz. Bataiyega
Thanks
Very Nice Trick Sir
Bhai iska ulta bhi kese hoga
Excel me select data one click me XML ya text format me save ho jaye. me copy paste nahi karan chata
Thanks