HW 1: Intro. to VBA and the Object Model (25 pts. Total

Added on - 18 Sep 2019

  • 2

    Pages

  • 580

    Words

  • 159

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
HW 1: Intro. to VBA and the Object Model (25 pts. Total)1. (6 pts)In this exercise, you will write expressions that refer to some ofthe objects in the Excel object model, which is shown in the following figure.a.How manycollectionsare shown in the above figure?b.For each of these collections, what type of objects are the members ofthis collection. For example, if the collection is people, the type of itsmember would be person?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 whosename is “My Workbook.xlsm”?f.What expression can be used to refer to the second Worksheet objectcontained in the Workbook object whose name is “MyWorkbook.xlsm”?2. (6 pts)In this exercise, you will write references to the objects found in aportion of the Microsoft Word object model, which is shown in the followingfigure.a. How many collections are shown in the above figure?b. What expression can be used to refer to the running Application, i.e.Microsoft Word?c. What expression can be used to refer to the Documents collection?d. What expression can be used to refer to the Document whose name is“My Document.docx” in the Documents collection?e. What expression can be used to refer to the first sentence contained inthe Document whose name is “My Document.docx”?f. What expression can be used to refer to the second word contained inthe Document whose name is “My Document.docx”?
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document