Visual Basic for Applications (“VBA”) is an implementation of Microsoft’s event-driven programming language Visual Basic 6.0 built into most desktop Microsoft Office applications.

Automating office tasks

Word, Excel, Access and PowerPoint are powerful applications each in their own right. Anyone who has used Word’s Mail Merge knows the joy of the many ways in which the applications are interoperable.

The next step is to use Macros to automate tasks and from there, it is not much of a stretch to start writing custom your own custom VBA code (even if it is with the help of a little Googling).

Learning to code

Fiddling around by recording Macros in Word and Access and then inspecting the generated code was my introduction to coding many years ago.

By MisterFoxOnline

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.