VBA

• Getting started with VBA
• API Calls
• Arrays
• Declaring an Array in VBA
• Dynamic Arrays (Array Resizing and Dynamic Handling)
• Iterating elements of an array
• Jagged Arrays (Arrays of Arrays)
• Multidimensional Arrays
• Use of Split to create an array from a string
• Assigning strings with repeated characters
• Attributes
• Automation or Using other applications Libraries
• Collections
• Comments
• Concatenating strings
• Conditional Compilation
• Converting other types to strings
• Copying, returning and passing arrays
• CreateObject vs. GetObject
• Creating a Custom Class
• Creating a procedure
• Data Structures
• Data Types and Limits
• Date Time Manipulation
• Declaring and assigning strings
• Declaring Variables
• Error Handling
• Events
• Flow control structures
• Frequently used string manipulation
• Interfaces
• Macro security and signing of VBA-projects/-modules
• Measuring the length of strings
• Naming Conventions
• Non-Latin Characters
• Object-Oriented VBA
• Operators
• Passing Arguments ByRef or ByVal
• Procedure Calls
• Reading 2GB+ files in binary in VBA and File Hashes
• Recursion
• Scripting.Dictionary object
• Scripting.FileSystemObject
• Searching within strings for the presence of substrings
• Sorting
• String Literals - Escaping, non-printable characters and line-continuations
• Substrings
• User Forms
• VBA Option Keyword
• VBA Run-Time Errors
• Working with ADO
• Working With Files and Directories Without Using FileSystemObject