VBA Notes for Professionals

VBA Notes for Professionals book

The VBA Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified.

Book created for educational purposes and is not affiliated with VBA group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners.

Contents:

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

Formato:  pdf Comprimido:  No Peso:  2.25 MB Lenguaje:  Inglés

Sin comentarios.

Deja tu Comentario