logo

Intro. to VBA and the Object Model

2 Pages580 Words174 Views
   

Added on  2019-09-18

About This Document

This exercise covers expressions that refer to objects in the Excel and Word object models. It includes finding useful websites for VBA programming. The exercise has a total of 25 points and is divided into five questions. The first two questions cover the Excel and Word object models, respectively. The third question is a multiple-choice question. The fourth question requires correcting an instruction. The fifth question requires finding three useful websites for VBA programming and explaining the rationale for the choices.

Intro. to VBA and the Object Model

   Added on 2019-09-18

ShareRelated Documents
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 of the objects in the Excel object model, which is shown in the following figure.a.How many collections are shown in the above figure? b.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?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”? f.What expression can be used to refer to the second Worksheet object contained in the Workbook object whose name is “My Workbook.xlsm”?2. (6 pts) In this exercise, you will write references to the objects found in a portion of the Microsoft Word object model, which is shown in the following figure.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 in the Document whose name is “My Document.docx”?f. What expression can be used to refer to the second word contained in the Document whose name is “My Document.docx”?
Intro. to VBA and the Object Model_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Intro. to VBA and the Object Model
|3
|819
|226

Data Analytics Assignment | Mathematics of Data Analytics
|18
|4515
|81

How to create templates - Overview of Macro
|14
|550
|38

Safety in Action - Assessment Workbook 3
|16
|1278
|44

BSBLDR403 Lead team effectiveness Workbook
|8
|1426
|207

Knowledge Assessment3 of 3
|19
|2534
|395