VBA Function To Check If A File Is Open

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

Save a Backup Every Time When You Save Excel File

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

Send an Email Every Time When You Save Excel File

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

List Hyperlinks From All The Worksheets with VBA

May 6, 2019 | Excel, VBA

If you work with an Excel workbook that contains many hyperlinks across many worksheets, and you want to create a report to list out the information of each hyperlink, doing that manually sounds crazy to me (I have seen that in real live that actually...

Merge Multiple CSV Files in Excel with VBA

Apr 30, 2019 | Excel, VBA

Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to...