|
Provided by: NobleProg - IT training courses Excel VBA AdvancedExcel |
 |
|
|
||||||||||||||||||||
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
