Pages Menu
Categories Menu

Most recent articles

Introduction to VBA in Microsoft Outlook

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

 

Programming with VBA in Outlook allows for document manipulation that may be awkward or even impossible with standard presentation techniques. This may be accomplished by writing code directly in the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization. To find out how to access the VBE by adding the developer toolbar to your excel 2007, 2010 and 2013 versions of Outlook, please follow the appropriate link in the Related Articles section.

Introduction to OLE Automation

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

 

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.

Introduction to VBA

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

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.

What is VBA?

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

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.

Page 5 of 512345