Copy & Paste An Excel Table Into Microsoft Word With VBA

Copy & Paste An Excel Table Into Microsoft Word With VBA

In this post you will learn how to write VBA code to automate copy and pasting an Excel table range into a new Word document.  The article should provide a good foundation to allow you to create a personalized VBA macro that suites your specific task needs.

Read More

Turn Off Annoying Error Alerts in Visual Basic Editor (VBE)

Turn Off Annoying Error Alerts in Visual Basic Editor (VBE)

When I first started coding in the Visual Basic Editor (VBE) I always got so annoyed with the message box alerts that would pop up every time I didn’t use proper syntax.  This caused me to get distracted since every time I didn't type something in properly I would get an error alert and have to click the OK button (usually occurred every other minute).

Read More