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

Microsoft Word VBA To Save Document As A PDF In Same Folder

Microsoft Word VBA To Save Document As A PDF In Same Folder

Below is a simple VBA macro that will allow you to quickly turn your Microsoft Word Document into a PDF file in a snap. The code is written to save your PDF in the same folder as the Word Document file currently resides. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to your specific needs.

Read More

PowerPoint VBA To Save Presentation As A PDF In Same Folder

PowerPoint VBA To Save Presentation As A PDF In Same Folder

A simple VBA macro that will allow you to quickly turn your current PowerPoint presentation into a PDF file in a snap. The code is written to save your PDF in the same folder as the PowerPoint file currently resides. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to your specific needs.

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

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

When you are trying to understand an unfamiliar workbook or Excel model, it can immensely help knowing which tabs are feeding into the one you are currently viewing. This little macro will give you a message box indicating any outside worksheet references found in the cell formulas of the ActiveSheet. 

Read More

VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

I deal with shapes and charts on a daily basis and one of my (many) pet peeves is needing to resize column widths and screwing up the size of my shapes and charts. I'm going to share with you a few VBA macros that will allow you to change the Placement property of all the shapes and charts on your ActiveSheet with the click of the button. The last VBA snippet is the one I use personally almost daily. Enjoy!

Read More

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

Below is a simple VBA macro that will allow you to quickly turn your selected worksheet(s) into a PDF file in a snap. The code is written to save your document in the same folder as the Excel file currently resides. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to your specific needs.

Read More