VBA in Excel - Part 2

Use comparison operators and system functions

Use Arrays

Work with ranges

Work with the worksheets and workbooks collections and objects

Use application objects

Use the FileSystemObject

Create function procedures

Import and save text files

Connect to other applications

Using Comparison operators and functions

The LIKE function

Wildcards

Using SELECT Case

The VAL function

Case functions

Trim functions

Text functions

Date functions

Using Excel functions in VBA

Creating arrays

Using arrays

Ubound and Lbound

Single and multi dimensional arrays

Static vs dynamic arrays

Creating range objects

Passing data between range objects and arrays

Using Transpose

The object browser

Collections

Creating object variables

Setting object variables

The For Each . . . Next Loo

The worksheets collection

The worksheet object

The sheets collection

Using object

Grouping worksheets

Using Typename

The workbooks collection

Setting workbook variables

Excel default information

Display/alerts

Screen updating

Status bar

On Time

Using Wait

Showing dialog boxes

Using dialog boxes

Searching for files and folders

The DIR function

The FileSystemObject

Creating functions

Adding arguments

Calling functions

Searching for files and folders

The DIR function

The FileSystemObject

Using the FILE and FOLDER collections

Early vs Late Binding

Setting references to other applications

Creating application variables

Setting application variables