How to open a password protected file in VBA

Thursday, July 25, 2019

The below VBA code will open a password protected file in VBA in Excel automatically while running VBA code so that you don't have to manually type in…

Read More

Add Module from Module

Tuesday, September 5, 2017

Adding modules from modules is useful in VBA for two reasons. 1. The more you know, the more flexibility you have when working on large projects. 2. You…

Read More

Procedure Too Large Error Message Fix

Wednesday, August 23, 2017
Procedure Too Large

Procedure Too Large Error Message Fix How to Fix Compile Error: Procedure Too Large The error message "Compile error: Procedure too large" appears in Excel 2007, 2010, and…

Read More

How to Send an Email with VBA in Outlook 2007, 2013, and 2016

Monday, August 21, 2017
VBA Email Outlook

How to Send an Email with VBA in Outlook 2007, 2013, and 2016 The below Youtube video will show you how to send VBA emails in Outlook 2007,…

Read More

Userforms

Monday, August 21, 2017
Userforms VBA

Userforms Stock Application 5 (1) The above Youtube video will show you how to use VBA Userforms. Userforms are objects in Microsoft Excel 2007, Excel 2010, and Excel…

Read More