VBA Notes for Professionals book
If you found this VBA book useful,
then please share it ❤
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
What people are saying about Notes for Professionals books
Wow. This is awesome. Thank you!
This is perfect for me who's learning to code!
From time to time, one comes across a bundle that is worth exploring. Today, a series of books called Programming Notes for Professionals over at http://books.goalkicker.com/ Have fun exploring #freeBooks #technology #bundle
Big thank you! Ended up downloading all of them as they touch on various different areas I work in daily. Big thanks for sharing, and even bigger thanks to those who wrote them.
This looks fantastic. Major thanks!
Good Technical stuff for beginners and intermediates who is looking to learn any technology.
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
210 pages, published on February 2018
To support continued development and improvements to this book, please consider a small bitcoin donation: 1H63m55bw6KDYUaKU1mYLGrzDf4wcrVzhX