VBA vs Object Oriented

[lezawang]

Hi
I can do the following

Workbooks("test1.xlsx").Worksheets("sheet1").Range("a1:b1") = "test"

to me that means "Worksheets" is a member of "Workbooks" class; otherwise excel would not accept:

Workbooks.Worksheets

But when I check the members of "Workbooks" class, I do not see Worksheets as a member? So why Workbooks.Worksheets is acceptable? Thank you indeed.

 

[cerfani]

Workbooks("test1.xlsx") is a Workbook object... and not a Workbooks object which is a collection of Workbook objects

Workbooks <> Workbook

 

[lezawang]

Thanks for your reply.
I am a bit confused now because the website below mentioned the following:
"

A Workbook object can be accessed from the Workbooks Collection​

"

To me that means Workbook is an object of Worksheets.
But I think you are right because Workbook has Worksheets

So the class is Workbook and the objects are Worksbooks and Worksheets which both inside Workbook. Am I right?

 

[lezawang]

Sorry the website is this

http://www.excelfunctions.net/Excel-Objects.html

 

[shg]

Workbooks is the collection of workbooks currently open in the Excel session.

Workbooks(x) returns a member of that collection -- a workbook object.

 

[lezawang]

Got it. Thank you all.