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: | 100 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Others VBA Tutorials
Introduction to Excel VBA Macro programming
Excel VBA tutorial for professionals
Learning access-vba PDF course
Others related eBooks about VBA Notes for Professionals
Android TutorialThis tutorial is a brief overview of some Android concepts designated to beginners who want to learn the basics of Android programming language. It's a free training couses in PDF under 48 pages by Larry Walters....
Practical C++ programmingThis tutorial is devoted to practical C++ programming. It teaches you the mechanics of the language, free training document under 549 designated to all level users....
Programming Computer Vision with Python: Tools and Algorithms for Analyzing ImagesThis book is a hands-on introduction to computer vision using Python....
PC Assembly LanguageThe purpose of this book is to give the reader a better understanding of how computers really work at a lower level than in programming languages like Pascal. The tutorial has extensive coverage of interfacing assembly and C code and so might be of interest to C programmers who want to learn about...
Word 2010 advanced part 1Advanced tutorial about Microsoft Word 2010, download free course for beginners in PDF....
Open Data Structures (in C++)Download free course Open Data Structures (in C++), pdf file on 336 pages by Pat Morin....
Learning C#Download a complete tutorial on C # entitled "Learn C #", PDF document on 1027 pages created by StackOverFlow....
How To Make Video GamesLearn How To Make Video Games, This ebook shows you everything you need to know to make video games....
Learning JavaJava is a class-based, object-oriented programming language that is designed to have as fe..., download free Java tutorial in PDF (1225 pages) created by ....
Introduction to Programming using Fortran 95/2003/2008This text provides an introduction to programming and problem solving using the Fortran 95/2003/2008 programming language. This introduction is geared for non computer science majors. As such, this text is not a complete, comprehensive guide to the Fortran 95/2003/2008 programming language. The pri...