Business solutions Automating Microsoft

8. Understanding Objects

IN THIS CHAPTER

Introducing Objects

Reading and Setting Properties

Invoking Methods

Working with Collections

Working with an Object Model

Creating Your Own Objects

Working with Events

Introducing Objects

You’ve seen quite a few variables so far in this book. Recall that a variable is a named part of VBA code that holds a single value (for example, a number or a string of characters). Or in the case of an array variable, the variable can store multiple related values. But so far you’ve been exposed to only one type of variable, which you might call a simple variable (sometimes you’ll see the technical term scalar variable used for this type). There’s actually a second type called object variables, or just objects ...