Advanced VBA (online)

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