Excel Object Browser

Author Message
ericbremen24

  • Total Posts : 2
  • Scores: 0
  • Reward points : 0
  • Joined: 3/21/2006
  • Status: offline
Excel Object Browser Tuesday, March 28, 2006 7:00 AM (permalink)
0
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
 
#1
    ebgreen

    • Total Posts : 8227
    • Scores: 98
    • Reward points : 0
    • Joined: 7/12/2005
    • Status: online
    RE: Excel Object Browser Tuesday, March 28, 2006 8:39 AM (permalink)
    0
    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
     
    #2
      ebgreen

      • Total Posts : 8227
      • Scores: 98
      • Reward points : 0
      • Joined: 7/12/2005
      • Status: online
      RE: Excel Object Browser Tuesday, March 28, 2006 8:41 AM (permalink)
      0
      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
       
      #3

        Online Bookmarks Sharing: Share/Bookmark

        Jump to:

        Current active users

        There are 0 members and 1 guests.

        Icon Legend and Permission

        • 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
        • Read Message
        • Post New Thread
        • Reply to message
        • Post New Poll
        • Submit Vote
        • Post reward post
        • Delete my own posts
        • Delete my own threads
        • Rate post

        2000-2012 ASPPlayground.NET Forum Version 3.9