Pages Menu
Categories Menu

Posted by on Aug 5, 2013 in Tutorials | 0 comments

Introduction to OLE Automation


OLE Automation, or “Automation” as it is commonly referred to, is an inter-process communication method created by Microsoft to allow scripting languages such as Visual Basic for Applications (VBA) to control automation objects.  What this means in the realm of Microsoft Office and VBA is that a programmer can write code in one software application (ie. Word) that has the ability to control another (ie. Outlook).  There are several reason a user might want to do this, and quite often centers around data enrichment, or reporting.

Read More

Posted by on Aug 3, 2013 in Tutorials | 0 comments

Introduction to VBA

I find that people who are new to VBA have very grandiose goals.  They want to take all the work they do in the course of a day, or even a week, and automate every last step of it.  While in theory this would be amazing, it’s not always practical, and certainly not the best place for a beginner to start.  You’d be surprised how much time you can save by automating small things like applying a custom number format to cells in Excel, or converting text into hyperlinks in a word document.

Read More

Posted by on Aug 1, 2013 in Tutorials | 0 comments

What is VBA?

Visual Basic for Applications (VBA) is a programming language primarily found in Microsoft Office products (Excel, Word, PowerPoint, Access etc.), and serves mainly as a tool for automating workflows. It helps take repetitive and sometimes complicated tasks prone to human error, and executes them for you. A well thought out VBA script can not only save you a lot of time but can also drastically improve the accuracy for your work.

Read More