Consulting

Results 1 to 3 of 3

Thread: Turn Excel Object Broswer into a 4-column long list, in Excel

  1. #1
    VBAX Regular
    Joined
    Apr 2010
    Posts
    19
    Location

    Turn Excel Object Broswer into a 4-column long list, in Excel

    Hello All,

    I need an Excel macro that will loop through following object libraries: Excel, Office, stdole, and VBA, then for each library will loop through all object Classes, on each class it will loop through all class members and create a table having following 4 columns: Library, Class, Member and Type, where type can be Function, Constant, Sub, Property, Enum, etc.

    Table must start from cell A1 of the Sheet1 tab.

    I suppose I need to activate/tick first Microsoft Visual Basic for Applications Extensibility 5.3.

    I expect the list will contain thousands of rows, maybe more.

    This would basically be an exact replica of Excel Object Browser, but turned into an Excel list.
    Excel Object Browser.jpg


    Could anyone please generate the code ? Or is the code available somewhere else ?

    Thank you in advance !

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Just out of interest.... Why? Microsoft has put a lot of time effort and money into making the Object browser very usable as it is.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Regular
    Joined
    Apr 2010
    Posts
    19
    Location
    I just want to consolidate in one big list all possible functions available in Excel, including VBA functions. Can you, or someone else provide a solution, please ? Thank you once again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •