Excel VBA Advanced Training Course
Overview
This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming, advanced VBA functionality and integration with external libraries and data sources.
Requirements
Good VBA knowledge.
Duration
14.00 hours
Course Prices
Prices for Instructor-led Online Courses:
If your company is based in the UK, VAT will be applied to the prices above.
Too Expensive? Tell us your price!
Too Expensive? Tell us your price!
Courses You May Take Before The Course
Classroom Courses
Course Outline
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
