Lesson#3 Objects and the Excel Object Model

Question 1

What is the Excel Object Model?

Answer 1

The objects in Excel which are organised in a local hierarchy.

Question 2

Which object is at the top of the hierarchy?

Answer 2

Application

Question 3

What are the 3 basic steps to navigate the Excel Object Model?

Answer 3

1. Start at the top of the model, with the Application object.
2. Use properties to return objects.
3. Use dots (.) to connect the different objects/properties.
   e. g. Application.Workbooks.Worksheets

Question 4

What are the 2 ways you can identify an individual object from within a collection?

Answer 4

Index number and objects name.

Question 5

What are the 3 basic rules for placing an index number or object name within a statement?

Answer 5

1. No. or Name is placed after collection name.
2. Index number is wrapped within parentheses. (Collection(#)).
3. Object name is wrapped within double quotes and parentheses. (Collection(“ObjectName”).

Question 6

How do you simplify fully-qualified references?

Answer 6

You can omit the Application object.