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: | 130 |
| 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
Introduction to VBA in Excel - PDF Tutorial
Learning access-vba PDF course
VBA Excel 2010, 2013 and 2016 Tutorial in PDF
Others related eBooks about VBA Notes for Professionals
You Don't Know JS Yet: Scope and ClosuresDownload free course You Don't Know JS Yet: Scope and Closures, pdf file on 279 pages by Kyle Simpson....
FreeSWITCH 1.6 CookbookFreeSWITCH is an open source carrier-grade telephony platform designed to facilitate the c..., download free FreeSWITCH 1.6 Cookbook tutorial in PDF (190 pages) created by Anthony Minessale II ....
Mastering iOS Game DevelopmentiOS is an operating system for Apple manufactured phones and tablets. Mobile gaming is one..., download free Game Development tutorial in PDF (228 pages) created by Miguel DeQuadros ....
Fortran 90 for BeginnersDownload free Fortran 90 Programming language course material, tutorial training, a PDF file by Tadziu Hoffmann & Joachim Puls....
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...
TouchDevelop - Programming on the GoMobile devices such as smartphones and tablets are set to become the main computersthat virtually all people will own and carry with them at all times. And yet,mobile devices are not yet used for all computing tasks. A project at MicrosoftResearch was created to answer a simple question: It is possi...
Android video game tutorialWith this tutorial you will learn how to create an android video game and the basics of android applications development, free training document on 34 pages by Nikhil Yadav....
GUI Design for Android AppsDownload free course GUI Design for Android Apps, pdf file on 147 pages by Ryan Cohen, Tao Wang....
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...
Agile Processes, in Software Engineering, and Extreme ProgrammingDownload free course Agile Processes, in Software Engineering, and Extreme Programming, pdf file on 343 pages by by Helen Sharp, Tracy Hall....