As I understand it, the WORKBOOKS object is a collection of WORKBOOK objects. So I would have expected to see the WORKBOOK object contained within the WORKBOOKS object, but I don't. How come?

Other than using F2 in the VB Excel editor for documentation on the different classes, is there a more thorough site offered by MS that clearly shows the Excel hierarchy with the properties and methods. I know Java has something like that and would assume VBA Excel would as well; if so, where is it?

Thanks,
Dan

I am not sure if I get you correctly, if I do I think you got this wrong.
Workbook is a member of Workbooks collection.
Workbooks is in turn a list of all "open" Workbooks.
Codewise: if you create the collection you 1st need to initialise it, set it to Application.Workbooks.

Actually I'd avoid creating a collections variable if my program needs to be dynamic. I'd always call application.workbooks because the variable will not automatically update if any Workbooks are created after it is initialised.
Another thing to look at is the fact that if you manually create a Workbook it will not be added to the application.collection till you save it.

The key thing here is that it is a collection of "open" workbooks.
About a link I'll check if I still have some.

__________________
Nostalgia 4 Infinity

You say that the Workbook object is a member of the Workbooks object but yet when I go here (the documentation I was hoping to discover):
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx
it does not show the relation of Workbook to Workbooks.

Thank you for your suggestions in your reply, I wasn't aware of those "gotcha".
Dan

The relationship is Item. A specific open workbook is an Item in the in the workbooks collection.

Check this:
expression .Item(Index)

And this: https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Use Workbooks(index), where index is the workbook name or index number, to return a single Workbook object. The following example activates workbook one.
And this:
And this: https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

This example sets the wb variable to the workbook for Myaddin.xla.
In C++ terms: Is is more like having a class as a member of another class as opposed to an object of a class.
I suspect your mind kind of expects the 2 to have the same class structure.

__________________
Nostalgia 4 Infinity