Building a folder generator app in Excel

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

Reporting Automation For Beginners (Code Included)

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

How to create a progress bar userform with 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...

VBA Function To Check If A File Is Open

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