Topics
- Getting started with excel-vba
- Getting started with VBA
- Declaring Variables
- Scripting.FileSystemObject
- VBA Best Practices
- Creating a procedure
- Flow control structures
- Comments
- Arrays
- Error Handling
- Data Types and Limits
- String Literals - Escaping, non-printable characters and line-continuations
- Declaring and assigning strings
- Working with ADO
- Scripting.Dictionary object
- Date Time Manipulation
- Working With Files and Directories Without Using FileSystemObject
- Operators
- Collections
- Passing Arguments ByRef or ByVal
Examples
- Declaring Variables
- Constants (Const)
- Type Hints
- Accessing the Visual Basic Editor in Microsoft Office
- Creating a FileSystemObject
- Reading a text file using a FileSystemObject
- Creating a text file with FileSystemObject
- Introduction to procedures
- Switch off properties during macro execution
- Select Case
- Apostrophe Comments
- For loop
- Enumerate files in a directory using FileSystemObject
- Use of Split to create an array from a string
- Early Binding vs Late Binding
- On Error statement
- Resume keyword
- Retrieve only the path from a file path
- Byte
- Integer
- Boolean
- Long
- Single
- Double
- Currency
- Date
- String
- LongLong
- Variant
- LongPtr
- Using VBA string constants
- Assign specific characters within a string using Mid statement
- Assignment to and from a byte array
- Making a connection to a data source
- Retrieving records with a query
- Executing non-scalar functions
- Creating parameterized commands
- Properties and Methods
- Iterating elements of an array
- Calendar
- Base functions
- Extraction functions
- Calculation functions
- Conversion and Creation
- Multidimensional Arrays
- Determining If Folders and Files Exist
- Creating and Deleting File Folders
- Mathematical Operators
- Concatenation Operators
- Comparison Operators
- Bitwise \ Logical Operators
- Adding Items to a Collection
- Removing Items From a Collection
- Getting the Item Count of a Collection
- Retrieving Items From a Collection
- Determining if a Key or Item Exists in a Collection
- Clearing All Items From a Collection
