(Two Days – 9.30 am to 5.00 pm)
A macro is a collection of commands that you can apply with a single click. They can automate almost anything you can do in the program you’re using and even enable you to do things you might not have known were possible. Macros are programming, but you do not need to be a developer or even have programming knowledge to use them. Most macros you can create in the Office programs are written in a language called Microsoft Visual Basic for Applications, usually referred to as VBA. VBA macros are the type addressed in this article. Macros save time and expand the capabilities of the programs you use every day. They can be used to automate repetitive document production tasks, streamline cumbersome tasks, or create solutions such as automating the creation of documents that you and your colleagues use regularly.