Case-Based Critical Thinking Questions
Case 12-2
Your cousin Rebecca knows that you are an experienced VBA programmer so she turns to you for some general guidance when she wants to get started as a programmer herself.
-What would you tell Rebecca to use if she wants to refer to a workbook that is named "Hilton Hotels"?
A) Workbooks("Hilton Hotels")
B) Excel("Hilton Hotels")
C) Book("Hilton Hotels")
D) Worksheets("Hilton Hotels")

Question

Quizplus · Accepted Answer

In VBA, to refer to a workbook by its name, we use the Workbooks object followed by the name of the workbook in parentheses. Therefore, the correct syntax would be Workbooks("Hilton Hotels"). This option A is the only choice that has the correct syntax. Option B is incorrect as there is no Excel object in VBA. Option C is incorrect as there is no Book object in VBA. Option D is incorrect as Worksheets refer to the individual sheets within a workbook, not the workbook itself.