The ONE Excel Feature I Wish I Knew Sooner

[@launchexcel]

*Watch this video next* This ONE Excel Hack Will Save You Hours kzbin.info/www/bejne/qKS5qaSupLKGesk *Click here for the article with full VBA code:* www.launchexcel.com/export-excel-worksheets-to-separate-files-vba *Learn how to set up and use your Personal Macro Workbook:* www.launchexcel.com/excel-personal-macro-workbook *Download the sample workbooks with full VBA code in a ZIP file:* d1yei2z3i6k35z.cloudfront.net/2762499/66ed4c5fdaf87_Export-Excel-Worksheets-with-VBAv2.zip *Chapters:* 00:00 Export 30 Sheets Fast! 00:30 Do you use Excel like it's an old car? 01:07 Benefits of VBA 01:33 Unlock VBA secret menu 01:58 DEMO 03:05 Export one worksheet 09:56 Export ALL worksheets 13:01 Personal Macro Workbook 15:45 Don't stop here... This ONE Excel Hack Will Save You Hours kzbin.info/www/bejne/qKS5qaSupLKGesk

[@alexrosen8762]

Your style of teaching is 👌

[@iyerravi44]

Excellent...except you were calm while explaining while I was nail-biting. You see when its coding, there is no concept of I am 99% right. Things won't work. I am in that state. I currently have an excel workbook with 20 sheets for easy reference with distinct information. How do I adopt your code. Can you share the steps. Alternatively, can you come up with a reverse situation, where we need a set of such sheets to be consolidated into a workbook. I think it's not possible but with you it's worth a try!. Your explanation is exceptional.

[@MrDhunpagla]

Very informative...Mr. Chan....What if i have to make separate worksheets from a single report based on different groups

[@launchexcel]

Good question! I'm actually preparing a video to show how to split an Excel Table into separate worksheets based on category value. Keep an eye out for it, either next week or the week after. It could be what you need.

[@amadoutidjanely3588]

With .new programming languages emerging, is VBA not outperformed?

[@launchexcel]

Hi @amadoutidjanely3588! Great question! While newer programming languages like Python and Office Scripts are gaining traction, VBA is a very powerful tool for Microsoft Office automations and building desktop solutions across many applications. It's built directly into Excel and other Office apps, making it accessible without any additional setup, and it excels at automating complex workflows within the Microsoft ecosystem. Python in Excel is a recent addition that allows users to run Python code directly within Excel formulas. This integration enables advanced data analysis, visualizations, and machine learning using popular libraries like pandas and Matplotlib. It’s a game-changer for data professionals working in Excel. However, it does have limitations, such as requiring a Microsoft 365 subscription and reliance on cloud-based execution for Python code, which may not suit all use cases. Office Scripts, on the other hand, is newer and works well in the cloud (Excel Online), but it is still rather limited in its functionality. For web-based Office automation, Office Scripts offers new possibilities but is best suited for simpler tasks at this stage. Ultimately, it’s about choosing the right tool for the job. If you need to automate Office processes quickly and effectively on the desktop, VBA is still the go-to choice because of its wide applicability and adoption. For more advanced data analysis within Excel, Python is now a powerful option. And for lightweight, web-based automation, Office Scripts is worth exploring as it continues to evolve. Hope this gives a clearer picture! 😊

[@Dexter101x]

Except with Tesla.....don't go there, lol

[@launchexcel]

lol, so you're not a Tesla fan?

[@Dexter101x]

@@launchexcel Deffo not a Tesla fan