• 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

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

Description

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.

Prerequisites

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

Skills

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

Concepts
VBA or Macro Recorder
Binding
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