Get in Touch
 Duration 14 hours

Course Outline

Excel Object Model

  • Protecting worksheets via VBA
  • Workbook object and Workbooks collection
  • Worksheet object and Worksheets collection
  • Validating worksheet content
  • Practical application of Range object methods
  • Copy, paste, and paste special operations
  • CurrentRegion property
  • Find and replace functionality
  • Sorting data ranges
  • Charts (Chart object)

Events

  • Application-level events

Arrays

  • Dynamic arrays
  • Variant type array tables
  • Optimizing arrays and memory usage
  • Multi-dimensional arrays

Object-Oriented Programming

  • Classes and Objects
  • Creating classes
  • Instantiating and destroying objects
  • Implementing methods
  • Defining properties
  • Data validation using properties
  • Default properties and methods
  • Error handling within class modules

Creating and managing collections

  • Initializing a collection
  • Adding and removing items
  • Accessing components using keys and indices

Advanced structures and functions VBA

  • Passing parameters by value and by reference (ByVal and ByRef)
  • Procedures with variable parameter counts
  • Optional parameters and default values
  • Procedures with an unspecified number of parameters (ParamArray)
  • Enums for streamlined parameter passing
  • User-Defined Types (UDT)
  • Handling Null, Nothing, empty string "", Empty, and 0
  • Type conversion

File Operations

  • Opening and closing text files
  • Reading and writing text and binary data
  • Processing records in CSV files
  • Optimizing text file handling

Integrating VBA functions into other applications

Additional Tools

  • Developing custom add-ins
  • Creating custom toolbars
  • Installing and protecting custom add-ins

Utilizing external libraries

Connecting to external databases (ODBC, OLEDB)

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories