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