• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

Advanced VBA - Office 2010 Bracknell

  • Price £645.00
  • Duration 2 day(s)
All major credit cards accepted


In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities using the Microsoft Office 2010 applications. The course covers examples in Excel 2010, Access 2010, Word 2010 and PowerPoint 2010.

NOTE that Microsoft Excel 2010 is used as the primary application during the course for demonstration purposes.

Target audience
Students looking to gain enhanced skills to apply VBA to develop macros to work with Office 2010 applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.


Delegates should have attended the course: Introduction to VBA in Office 2010 (QAVBA10INT), or have equivalent knowledge
                                                                                                                                                                                               A working knowledge of Excel 2010, Access 2010, Word 2010 and PowerPoint 2010

Understand how to create charts, PivotTables and apply filters and sorting of data sets


Delegates will learn how to:
                                                                                                                                                                                 Work with the Office 2010 Object Model
Create and use Object Variables
Create macros to work from application to application
Write VBA to work with data
Create User Defined Types, Classes and Arrays
Manage Files and Folders using VBA

Course Content

Lesson 1: Office 2010 Object Hierarchies and the Object Browser

Object Hierarchies and Collections
Properties, Methods and Events
Using the Object Browser
Office 2010 Application Reference Libraries

Lesson 2: Working Within an Application

VBA or Macro Recorder
Object Variables
Application Object Examples

Lesson 3: Interaction Between Office 2010 Applications

Classes and References
Working with Objects in Another Application
Editing Documents Across Office 2010 Applications

Lesson 4: Working With Data in Office 2010

Data and Terminologies
Manipulating Data in an Application
ADO and Connections – Working with Recordsets
Using Data Between Applications
Mail Merge
Charting Data in Office 2010

Lesson 5: User Defined Types and Arrays

Create a User Defined Type
Creating a Class
Creating Array Variables
Using Arrays in Code

Lesson 6: File and Folder Management Using VBA

Using the FileSystemObject
Handling Folders using VBA
Move, Rename, Copy or Delete a File Using VBA
Access File or Folder Attributes and Properties

Make Enquiry

Course Enquiry

Book Now

Course Enquiry

Find your local training centre

AddressVenture House
Downshire Way
RG12 1WA
Phone01423 534 630