Excel VBA

How to Remove PageBreaks in Excel with VBA

This post came about as a client of mine introduced a document classification product called Titus that works as an add-on to Microsoft Excel.  The Titus classification add-on caused an unexpected consequence, when you set the security classification of the…
Read more

How to close Excel using VBA

The need to close Excel after running a macro arises all the time especially in large-scale Excel reporting automations where you may be collating data from multiple Excel files.  To learn how to close Excel from within VBA then read…
Read more

Switch Alerts off with Excel VBA

A common problem achieving full VBA and Macro automation with Excel is that the warning messages can halt your script in the middle of processing.  Learn how to stop that problem and achieve full Excel automation with VBA… The problem…
Read more