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: | 120 |
| 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
Excel VBA tutorial for professionals
VBA Excel 2010, 2013 and 2016 Tutorial in PDF
Learning access-vba PDF course
Others related eBooks about VBA Notes for Professionals
Learning Java by Building Android GamesAndroid is the fastest growing operating system (OS) with one of the largest installed bas..., download free Java tutorial in PDF (392 pages) created by ....
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. By gaining a deeper understanding of how computers work, the reader can often be much more productive developing software in higher level lan...
Architect Modern Web Applications with ASP.NET Core and AzureDownload free course Architect Modern Web Applications with ASP.NET Core and Azure, pdf file on 113 pages by by Steve Smith....
Ruby Best PracticesDownload free course Ruby Best Practices, pdf file on 329 pages by Gregory T. Brown....
Python Machine Learning ProjectsDownload free course Python Machine Learning Projects, pdf file on 135 pages by Lisa Tagliaferri, Michelle Morales, Ellie Birkbeck, Alvin Wan....
Raspberry Pi Projects BookDownload free course Raspberry Pi Projects Book, pdf file on 204 pages by Wes Archer, David Crookes, PJ Evans, Gareth Halfacree, Rosie Hattersley, Nicola King, Ben Nuttall, Marc Scott, Danny Staple, Mark Vanstone....
Restful Web ServicesYou've built web sites that can be used by humans. But can you also build web sites that are usable by machines? That's where the future lies, and that's what RESTful Web Services shows you how to do. The World Wide Web is the most popular distributed application in history, and Web services and mas...
Python Machine Learning ProjectsThis book tries to equip the developers of today and tomorrow with tools they can use to better understand, evaluate, and shape machine learning....
Advanced Python, course with exercisesThis tutorial is a selflearning document in PDF for a course in Python programming intended to advanced students level....
Programming FundamentalsThis programming fundamentals tutorial in PDF format covers the key concepts and principles that are essential for anyone looking to become a proficient coder. The tutorial begins with an introduction to programming, explaining the basic concepts and terminologies that underlie all programming langu...