Ask a question to Desklib · AI bot

Ask NowBETA

Intro. to VBA and the Object Model

3 Pages819 Words226 Views
   

Added on  2019-09-19

About This Document

This exercise is about writing expressions that refer to objects in the Excel and Word object models. It also includes questions about displaying slide count and slide name. Additionally, it requires exploring websites that provide useful information about VBA programming and selecting three of them. The output is in JSON format.
BookmarkShareRelated 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? -- 2b.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? --Members of Workbooks: WorkbookWorksheet is a member of Worksheetsc.What expression can be used to refer to the running Application, i.e. Microsoft Excel?Applicationd.What expression can be used to refer to the Workbooks collection?Application.Workbookse.What expression can be used to refer to the Workbook object whose name is “My Workbook.xlsm”? Application.Workbooks(“My Workbook”)f.What expression can be used to refer to the second Worksheet object contained in the Workbook object whose name is “My Workbook.xlsm”?Application.Workbooks(“My Workbook”).Worksheets(“Sheet2”)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.
Intro. to VBA and the Object Model_1

Found this document preview useful?

Related Documents
Intro. to VBA and the Object Model
|2
|580
|174

Data Handling and Business Intelligence Report
|13
|3501
|33

Maintaining Homeostasis in a Marathon: Assessment and Worksheet
|20
|5353
|90

FNSACC311 - Process financial transactions
|37
|5607
|11

Continuous Improvement and Risk Management
|24
|5189
|52

Safety Management Systems - Assessment Workbook 2
|12
|1047
|68