Duration

1 day

Introduction

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.

Objectives

Upon completion of the course delegates will have a good understanding of the major components of VBA.
Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.
In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.

Lesson 1: Working with the PivotTable Object

Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with PivotTable Objects
Working with PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Lesson 2: Debugging Code

Understanding Errors
Using the Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Lesson 3: Handling Errors

Understanding Error Handling
Understanding VBA’s Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

Programme scope, delivery arrangements and suitability are confirmed during enquiry.