VBA Notes for Professionals
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 |
| File type : | |
| Downloads: | 139 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others VBA Tutorials
Learning access-vba PDF course
Introduction to VBA in Excel - PDF Tutorial
Others related eBooks about VBA Notes for Professionals
Deep Learning in Neural Networks: An OverviewIn recent years, deep artificial neural networks (including recurrent ones) have won numerous contests in pattern recognition and machine learning. This historical survey compactly summarises relevant work, much of it from the previous millennium. Shallow and deep learners are distinguished by the...
Neural Networks with JavaScript SuccinctlyDownload free course Neural Networks with JavaScript Succinctly, pdf file on 163 pages by James McCaffrey....
Android on x86Download free course Android on x86, pdf file on 375 pages by by Iggy Krajci, Darren Cummings....
Programming in LuaThis book is for students and professionals who are intrigued by the prospect of learning and using a powerful language that provides a rich infrastructure for creating programs. No programming knowledge is necessary to benefit from this book except for the section on Lua bindings, which requires so...
Microservices Best Practices for JavaDownload free course Microservices Best Practices for Java, pdf file on 134 pages by Michael Hofmann, Erin Schnabel, Katherine Stanley....
Csharp Programming TutorialDownload this C# PDF Tutorial for free, it's consisting of 5 chapters covering all the most important C# concepts. This tutorial is intended for beginner programmers, and we recommend you to go through all the chapters, to get the most out of it as possible....
3D Game Development with LWJGL 3This book introduces the main concepts required to write a 3D game using the LWJGL 3 library....
TypeScript eBook for professionalsDownload free TypeScript tutorial course in PDF, training file in 30 chapters and 97 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Entity Framework tutorial for professionalsDownload free Entity Framework tutorial course in PDF, training file in 23 chapters and 94 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
C programming tutorial for professionalsDownload free C language tutorial course in PDF, training file in 63 chapters and 342 pages. Free unaffiliated ebook created from Stack OverFlow contributor....