How can we get a complete list of ExcelApp properties in hard copy?

Add-in Express™ Support Service
That's what is more important than anything else

How can we get a complete list of ExcelApp properties in hard copy?
 
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

If we type "ExcelApp." in Visual Studio, IntelliSense will display an exhaustive list of all Properties (and maybe other things too) appropriate to ExcelApp.

Is there any way to copy this whole list to Excel (for learning purposes)?

If not, where can I get such a listing?


Best Regards,
Leon
Posted 20 Mar, 2019 02:59:11 Top
Andrei Smolin


Add-in Express team


Posts: 16662
Joined: 2006-05-11
Leon,

- Start Excel.
- Press {Alt}+{F11} or click the Visual Basic button on the Developer tab; this opens the VBA IDE.
- In the VB IDE, choose View | Object Browser in the main menu or just press {F2}; this opens the Object Browser window.
- In the topmost combo of the Object Browser window select "Excel".
- in the Classes list select Application.

Now see the right list; it's now labelled "Members of 'Application'". Right-clcik the list to see available options.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Mar, 2019 05:32:00 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

Great and very helpful suggestion! Thanks a lot.

But do you know any way you could select the whole list and copy it to Excel or Word?

Apart from Printscreen or Snipping tool, I have no idea.

Best Regards,
Leon
Posted 20 Mar, 2019 06:35:23 Top
Andrei Smolin


Add-in Express team


Posts: 16662
Joined: 2006-05-11
Leon,

See https://docs.microsoft.com/en-us/office/vba/api/excel.application(object).

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Mar, 2019 06:50:10 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Unfortunately, link is dead.

Added:
I found it by doing a search. It's the same as the URL you gave.


Thanks a lot!

Leon
Posted 20 Mar, 2019 06:52:12 Top
Andrei Smolin


Add-in Express team


Posts: 16662
Joined: 2006-05-11
Leon,

The forum engine didn't recognized the concluding bracket as part of the hyperlink. Copy the hyperlink including the closing bracket (and excluding the dot) and paste it in the address box of your browser.

We will look in this issue.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Mar, 2019 07:04:02 Top