How to export API library from VBA in Excel

[excelforbreaky]

Hello all,

How can i export the entire API library I see on Object Browser via the Microsoft VBA in Excel like the attached screenshot? Instead of me copying each member/command one by one via right-click?

 

[John_w]

The Turn Excel VBA Object Browser into a 4-column long list thread in the Similar threads list at the bottom of this page includes several methods to extract information from the Object Browser.

My method, which extracts classes, members, properties and sub and function parameters from specified libraries is here:

Turn Excel VBA Object Browser into a 4-column long list

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...

www.mrexcel.com