Topics

• Declaring Variables
• Scripting.FileSystemObject
• VBA Best Practices
• Flow control structures
• Comments
• Recursion
• Data Types and Limits
• String Literals - Escaping, non-printable characters and line-continuations
• Declaring and assigning strings
• Converting other types to strings
• Searching within strings for the presence of substrings
• Substrings
• Measuring the length of strings
• Concatenating strings
• Assigning strings with repeated characters
• VBA Option Keyword
• Installing VB6 on Windows 10
• Creating a Custom Class

Examples

• Constants (Const)
• Type Hints
• Apostrophe Comments
• REM Comments
• For loop
• Avoid using SELECT or ACTIVATE
• Recursively enumerate folders and files
• Factorials
• Folder Recursion
• Escaping the " character
• Assigning long string literals
• Using VBA string constants
• Declare a string constant
• Declare a variable-width string variable
• Declare and assign a fixed-width string
• Declare and assign a string array
• Assign specific characters within a string using Mid statement
• Use CStr to convert a numeric type to a string
• Use Format to convert and format a numeric type as a string
• Use StrConv to convert a byte-array of single-byte characters to a string
• Implicitly convert a byte array of multi-byte-characters to a string
• Use InStr to determine if a string contains a substring
• Use InStr to find the position of the first instance of a substring
• Use InStrRev to find the position of the last instance of a substring
• Use Left or Left$ to get the 3 left-most characters in a string
• Use Right or Right$ to get the 3 right-most characters in a string
• Use Mid or Mid$ to get specific characters from within a string
• Use Trim to get a copy of the string without any leading or trailing spaces
• Use the Len function to determine the number of characters in a string
• Use the LenB function to determine the number of bytes in a string
• Prefer `If Len(myString) = 0 Then` over `If myString = "" Then`
• Concatenate strings using the & operator
• Concatenate an array of strings using the Join function
• Use the String function to assign a string with n repeated characters
• Use the String and Space functions to assign an n-character string
• Decimal
• Option Base {0 | 1}
• Installation Wizard
• Declaring Fixed-Length Strings
• Class module scope, instancing and re-use
• Using FSO.BuildPath to build a Full Path from folder path and file name