Microsoft Visual Basic training - Advanced Visual Basic for Applications 2007 (2 days)

If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!

Advanced Visual Basic for Applications 2007 training - Course Contents

The contents of our Advanced Visual Basic for Applications 2007 course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please call or email us to talk through your options. We want you to be on the right Microsoft Visual Basic training course as much as you do!

Revision of VBA
  • Objects and collections
  • Methods and properties
  • Looping over collections
  • Using object variables
Links to other applications
  • Referencing other applications
  • Creating object instances
  • CreateObject and GetObject
Working with files
  • The DIR function
  • Using FileSystemObjects
  • Working with files and folders
  • Using FileDialogs
Protecting applications
  • Trapping keys in Excel and Word
  • Trapping keys in Access
  • Disabling bypass keys
Security
  • How macro security works
  • Creating security certificates
  • Digitally signing macros
Class modules
  • What is a class?
  • Designing classes
  • Creating properties and methods
  • Consuming classes
Advanced class modules topics
  • Untyped collections
  • Creating typed collections
  • Creating event sinks
Good programming techniques
  • Recursive programming
  • Passing arguments ByRef and ByVal
  • Using optional arguments

To help see if this is the right course for you, you can see and download examples of our VBA 2007 courseware.

Advanced Visual Basic for Applications 2007 training - Pre-requisites

Delegates should have good knowledge of either Access Visual Basic, Excel Visual Basic, Word Visual Basic or Visual Basic itself. Delegates should also be familiar with the basics of the Microsoft Office applications, which will be used for some examples.

Advanced Visual Basic for Applications 2007 training - Schedule and Prices

Prices for this Microsoft Visual Basic training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Visual Basic training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Visual Basic training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Visual Basic training. This allows you to create a Microsoft Visual Basic training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Visual Basic which they need to learn.

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.