VBA Code To Find And Replace Words Within Specific File Names In A Folder

VBA Code To Find And Replace Words Within Specific File Names In A Folder

I often have a routine of copying files from one month to another. The only problem with this sort of process is I have to go through and modify all the file names to reflect the current month or time period. As you can imagine, this can be quite a timely task....and timely tasks are perfect for automation with VBA!

Read More

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

There may be times when you want to incorporate code from your add-ins into other VBA procedures or give others access to call your add-in macros. To prevent errors occurring in the off chance the add-in was unloaded or never installed, you can use VBA code to ensure the add-in is properly loaded into Excel, PowerPoint, or whatever Microsoft Office program you are using.

Read More

Prevent Your VBA Code From Running While In Read-Only Mode

Prevent Your VBA Code From Running While In Read-Only Mode

I had an instance where I needed to prevent users from running a workbook's macros unless the workbook was editable (not read-only).  This file was used by multiple people and my colleagues were accidentally updating the workbook while somebody else was already in the file.  This poses a problem since the changes could not be saved if the file was Read-Only. 

Read More