PROBLEM1: (6 pts) In this exercise, you will write expressions that refer to som

Question

PROBLEM1: (6 pts) In this exercise, you will write expressions that refer to some of the objects in the Excel object model, which is shown in the following figure Application Workbooks (Workbook) Worksheets (Worksheet) a) How many collectons are shown in the above tgure? 2 collections For each of these collections, what type of objects are the members of this collection. For example, if the collection is people, the type of its member would be person? worksheets b) c) What expression can be used to refer to the running Application, i.e. Microsoft Excel d) What expression can be used to refer to the Workbooks collection? e) What expression can be used to refer to the Workbook object whose name is "My Workbook.xlsm" ) What expression can be used to refer to the second Worksheet object contained in the Workbook object whose name is "My Workbook.xlsm"? +

Explanation / Answer

a) 2 collections - Workbook and Worksheet

b) members of workbook is worksheet (a workbook im an excel file contains one or more worksheets)

members of worksheet are cells (an excel worksheet contains cells organized by rows and columns)

rows and columns can also be treated as members of worksheet

c) Application

d) Workbooks

e) Application.ActiveWorkbook.My Workbook OR ActiveWorkbook.My workbook

f) My Workbook..Worksheets(2).Name

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.