Object Browser Question

[EricBremen24]

Does anyone understand the Object Browser in MS Excel?

Two questions:

1.) My understanding is that the Applicaiton object is the highest object in the hierarchy, yet in the object browser, there are multiple classes shown at the same level as Application - such as Addins, Adjustments, etc. Why doesn't the browser work like a tree?

2.) What is the <globals> class? Is it in fact a class?

Thanks,
Eric

 

[Legacy 98055]

1. You cannot use nested classes in pre-net VB. Though many of these classes are exposed as properties of the Application object, they are not actually contained within the application object it'self. For example, the Range object. Application.Range or Worksheet.Range both create an Excel.Range object based upon the "template" of the Range class. They simply have differing scope. Also, there is no rule that states that there must only be a single hierarchy within a model. So, simply put, at the top of the pecking order is Excel. Excel is not a class but a library name. You cannot create an instance of "Excel". All of the classes listed below are members of the Excel library. Any of these classes may contain properties that expose/create an instance of another class that belongs to Excel such as the "Range" property of the Application class that exposes an instance reference to an object created based upon the Range class. There is no range class of the Application class because, as stated, there is no such thing as nested classes in pre-net VB. Now that I have thorougly confused you, let's try number 2.

2. Perform a google search. There are plenty of good examples out there. Here is one.

http://en.wikipedia.org/wiki/Object-oriented_programming