Oct 28, 2019 | Excel, VBA
In this tutorial I am going to show you how to create a Folder Generator App in Excel. We will be writing some VBA to perform the folder creation. Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Download...
Aug 19, 2019 | Excel, VBA
Microsoft Excel Reporting Automation Excel VBA makes a amazing tool to automate reporting. If you work in Accounting or Finance, then being able to create a macro to automate a reporting that usually takes half hour to merely just a minute, and you can re-use the the...
Aug 19, 2019 | Excel, VBA
Excel Progress Bar UserformA progress bar is a great way to presenting the current progress of something that is currently running. In Excel, the software does not come with a progress bar widget by default, but that does not mean we cannot create it on our own.In...
Jun 19, 2019 | Excel, VBA
In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened. data-ad-client="ca-pub-3255865697013143" data-ad-slot="2278613244" data-ad-format="auto" data-full-width-responsive="true"> VBA...
Jun 11, 2019 | Excel, VBA
If you are working on a very critical project (like an audit), and you would like to keep a record of things every time when you save your Excel file. Despite Excel doesn’t provide the feature – save a backup when saving -, we however, can create the...
Jun 11, 2019 | Excel, VBA
With Excel VBA, you can implementing features that are not even exist in Excel. In this tutorial we will be creating an auto emailing feature every time when you save your Excel file a macro will automatically fire and sending an email either to yourself or to whoever...
