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.
Attachment 31443
http://www.vbaexpress.com/forum/imag...AASUVORK5CYII=

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

Thank you in advance !

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.

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.