Learning VBA eBook (PDF)
Download this eBook for free
Chapters
Chapters
- Chapter 1: Getting started with VBA
- Chapter 2: API Calls
- Chapter 3: Arrays
- Chapter 4: Assigning strings with repeated characters
- Chapter 5: Attributes
- Chapter 6: Automation or Using other applications Libraries
- Chapter 7: Collections
- Chapter 8: Comments
- Chapter 9: Concatenating strings
- Chapter 10: Conditional Compilation
- Chapter 11: Converting other types to strings
- Chapter 12: Copying, returning and passing arrays
- Chapter 13: CreateObject vs. GetObject
- Chapter 14: Creating a Custom Class
- Chapter 15: Creating a procedure
- Chapter 16: Data Structures
- Chapter 17: Data Types and Limits
- Chapter 18: Date Time Manipulation
- Chapter 19: Declaring and assigning strings
- Chapter 20: Declaring Variables
- Chapter 21: Error Handling
- Chapter 22: Events
- Chapter 23: Flow control structures
- Chapter 24: Frequently used string manipulation
- Chapter 25: Interfaces
- Chapter 26: Macro security and signing of VBA-projects/-modules
- Chapter 27: Measuring the length of strings
- Chapter 28: Naming Conventions
- Chapter 29: Non-Latin Characters
- Chapter 30: Object-Oriented VBA
- Chapter 31: Operators
- Chapter 32: Passing Arguments ByRef or ByVal
- Chapter 33: Procedure Calls
- Chapter 34: Reading 2GB+ files in binary in VBA and File Hashes
- Chapter 35: Recursion
- Chapter 36: Scripting.Dictionary object
- Chapter 37: Scripting.FileSystemObject
- Chapter 38: Searching within strings for the presence of substrings
- Chapter 39: Sorting
- Chapter 40: String Literals - Escaping, non-printable characters and line-continuations
- Chapter 41: Substrings
- Chapter 42: User Forms
- Chapter 43: VBA Option Keyword
- Chapter 44: VBA Run-Time Errors
- Chapter 45: Working with ADO
- Chapter 46: Working With Files and Directories Without Using FileSystemObject
Download this eBook for free
