Follow @WiseOwlTraining

Advanced VBA training course (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!

Click here to show prices, dates and venues for this course

Advanced VBA training - Course Contents

The contents of our Advanced VBA course are as follows (any items marked with a * will be covered if time allows):

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

FileSystemObjects

Referencing FileSystemObjects
Working with files and folders

FileDialogs

Using FileDialogs
Allowing multiple selection

Working with text files

Avoiding using INPUT/OUTPUT
Reading and writing text files

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

Linking to data (*)

ADO or Access Database Engine
Referencing the right library
Opening and using recordsets

Arrays

Creating and populating arrays
Dynamic arrays
The PRESERVE keyword

Passing arguments

ByRef and ByVal
Using optional arguments
Using ParamArray

Advanced programming ideas (*)

Recursive programming
Enumerations
Using functions in code

Click on any link above to show free exercises for the topic in question. 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. There will be a maximum of 6 people on each course, and each person will have their own computer.

Advanced VBA training course (2 days)

Advanced VBA training - Course Contents

Top menu

Microsoft Office

SQL Server training

.NET / SharePoint

Training venues

SITE MAP

Microsoft Office training and consultancy

SQL Server training and consultancy

.NET and SharePoint training

Computer training venues