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

[Romulus]

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 !

[Aussiebear]

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.

[Romulus]

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.