Advanced VBA (online)
Course
Online
Description
-
Type
Workshop
-
Level
Advanced
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
-
Virtual classes
Yes
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! Suitable for: This Advanced VBA course is aimed primarily at businesses and public sector organisations
Important information
Documents
- Advanced VBA course outline.pdf
Facilities
Location
Start date
Start date
About this course
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.
Reviews
Subjects
- VBA
- Links to other applications
- FileDialogs
- FileSystemObjects
- Working with text files
- Class modules
- Linking to data
- Arrays
- Passing arguments
- Revision of VBA
Teachers and trainers (2)
Andrew Gould
Senior Trainer
David Wakefield
Director / Programmer / Trainer
Course programme
Revision of VBA
- Objects and collections
- Methods and properties
- Using object variables
- Looping over collections
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
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
Working with text files
- Text files and FileSystemObjects
- Avoiding using INPUT/OUTPUT
- Creating and opening
Arrays
- Creating and populating arrays
- Dynamic arrays
- The PRESERVE keyword
Distributing classes in Excel
- Excel templates
- Sharing classes
- Excel add-ins
Linking to data
- ADO or Access Database Engine
- Referencing the right library
- Opening and using recordsets
Additional information
Advanced VBA (online)