Microsoft Excel training | Advanced Visual Basic for Applications (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 training - Course Contents

The contents of our Advanced Visual Basic for Applications 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 either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft Excel 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
  • Instantiating objects
  • Writing inter-application code
Working with files
  • Using FileSystemObjects
  • Working with files and folders
  • Using FileDialogs
Working with text files
  • Text files and FileSystemObjects
  • Avoiding using INPUT/OUTPUT
  • Creating and opening
Security
  • How macro security works
  • Creating security certificates
  • Digitally signing macros
Protecting applications
  • Trapping keys in Excel and Word
  • Trapping keys in Access
  • Disabling bypass keys
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
Distributing classes in Excel (*)
  • Excel templates
  • Sharing classes
  • Excel add-ins
Good programming techniques
  • Recursive programming
  • Passing arguments ByRef and ByVal
  • Using optional arguments
Arrays
  • Creating and populating arrays
  • Dynamic arrays
  • The PRESERVE keyword
Linking to data (*)
  • ADO or Access Database Engine
  • Referencing the right library
  • Opening and using recordsets

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

Advanced Visual Basic for Applications 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 training - Schedule and Prices

Prices for this Microsoft Excel 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 Excel 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 Excel training

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

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.