Download free course VBA Notes for Professionals, pdf file on 202 pages by Stack Overflow Community.
The Visual Basic .NET Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow.
Table of contents
- Getting started with VBA
- Comments
- String Literals - Escaping, non-printable characters and line-continuations
- VBA Option Keyword
- Declaring Variables
- Declaring and assigning strings
- Concatenating strings
- Frequently used string manipulation
- Substrings
- Searching within strings for the presence of substrings
- Assigning strings with repeated characters
- Measuring the length of strings
- Converting other types to strings
- Date Time Manipulation
- Data Types and Limits
- Naming Conventions
- Data Structures
- Arrays
- Copying, returning and passing arrays
- Collections
- Operators
- Sorting
- Flow control structures
- Passing Arguments ByRef or ByVal
- Scripting.FileSystemObject
- Working With Files and Directories Without Using FileSystemObject
- Reading 2GB+ files in binary in VBA and File Hashes
- Creating a procedure
- Procedure Calls
- Conditional Compilation
- Object-Oriented VBA
- Creating a Custom Class
- Interfaces
- Recursion
- Events
- Scripting.Dictionary object
- Working with ADO
- Attributes
- User Forms
- CreateObject vs. GetObject
- Non-Latin Characters
- API Calls
- Automation or Using other applications Libraries
- Macro security and signing of VBA-projects/-modules
- VBA Run-Time Errors
- Error Handling
| Pages : | 202 |
| Size : | 2.3 MB |
| Downloads: | 100 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Others related eBooks about VBA Notes for Professionals
Download free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface
Download VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF.
Download VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages.
Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor.