Question: Sub ListWorkbooks ( ) 'list all open files Dim w As Workbook For Each w In Workbooks Debug.Print w . Name Next w End Sub
Sub ListWorkbooks
'list all open files
Dim w As Workbook
For Each w In Workbooks
Debug.Print
wName
Next
End Sub
In this context, what is Workbooks?
A method
A Collection
A Property
An Object
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
