Excel VBA Advanced Training Course

Excel Object Model

Workbook and worksheet object
Workbooks and worksheets collections
Range object's properties and methods
Current Region object
Chart object
Statusbar
Timer
List object

Events

Events with application object

Arrays

Dynamic arrays
Arrays optimization
Multidimensional arrays
Arrays and objects

Object Oriented Programming (OOP)

Classes and objects
Set and Let statements
Creating new objects
Creating new classes
Destroying objects
Methods and properties
Default property and method
Classes and error handling

Collection

Creating and using collections
Adding and remove elements
Using index and key
Typed collection*

Procedures, parameters, variables

Passing parameters by reference and by value (ByRef i byVal)
Optional and default parameters
Passing an array of arguments to a procedure
Using enumerations
User-defined Type
Differences and use cases of Null, Nothing, empty string "", Empty, 0
Implicit and explicit conversions

Dealing with files

Reading text files
Using CSV files

Writing cross-application code

Using Excel Object Model in other applications

Add-ins

Creating simple add-in
Creating menu and toolbar in add-in
Deployment and securing add-ins

Using external libraries

Using external data sources (Access, Oracle, etc.)

Using ADO
Data providers
Configuring ODBC sources