Excel Object Browser

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Excel Object Browser

Logged in as: Guest

arrSession:exec spGetSession 2,7,32770

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> Excel Object Browser
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Excel Object Browser - 3/28/2006 6:00:57 AM

ericbremen24

Posts: 2
Score: 0
Joined: 3/21/2006
Status: offline

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

Post #: 1

RE: Excel Object Browser - 3/28/2006 7:39:17 AM

ebgreen

Posts: 4595
Score: 29
Joined: 7/12/2005
Status: offline

I will answer your question by not answering your question. If you want to look at the Excel object model, here is what I suggest. With a standard install of office, go to C:\program files\Microsoft Office\OFFICE11\1033 and open VBAXL10.chm. That is the best source that I have found for the Excel object model.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to ericbremen24)

Post #: 2

RE: Excel Object Browser - 3/28/2006 7:41:58 AM

ebgreen

Posts: 4595
Score: 29
Joined: 7/12/2005
Status: offline

From the Object Browser help:

"Displays all of the available classes in the library or project selected in the Project/Libraries box. If there is code written for a class, that class appears in bold. The list always begins with <globals>, a list of globally accessible members."

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to ebgreen)

Post #: 3

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> Excel Object Browser

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts