Course not currently available
Excel VBA Advanced
Course
In Manchester ()
Description
-
Type
Course
-
Level
Advanced
-
Class hours
14h
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. Suitable for: Good VBA knowledge required.
About this course
Good VBA knowledge.
Reviews
Subjects
- Excel
- Access
- Object oriented training
- Object-oriented training
- Microsoft Excel
- Spreadsheet
- Programming
- Object oriented Programming
- Oriented Programming
- MS Excel
Course programme
Course review:
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 librariesUsing external data sources (Access, Oracle, etc.)
Using ADO
Data providers
Configuring ODBC sources
Excel VBA Advanced