Handout of Excel Object's Properties and Methods

[Luis Carrion]

Does anyone know where can I find a complete list of Properties and
Methods of Excel Objects? I know that I can Find them on the Object
Browser but a printable handout is always handy.

Thanks.
LC

 

[Patrick Molloy]

Open HELP and search on "excel object model"
You can then kill as many trees as you want

Patrick Molloy
Microsoft Excel MVP

 

[Tom Ogilvy]

MS did publish a book that was essentially a printout of the Excel VBA help
file. I forget the name of it, but you might find it at

mspress.microsoft.com

Don't know if they still publish it. If I find the name of it later, I will
post a followup.

Regards,
Tom Ogilvy

 

[Luis Carrion]

I have those books you mentioned from Ms Press. Those series of books
contains the the help of Ms Office printed ... like 5000 pages.

What I meant was a quicklist like the one posted above.. So I can
Quickly view which properties and methods could be used with an
specific object..

Thanks For the responses.
LC

 

[Tom Ogilvy]

Go to Chip Pearsons site

http://www.cpearson.com/excel.htm

scroll down until you see the entry for

Download XLTLI - Type Lib Utilities
http://www.cpearson.com/Zips/TLIUtils.ZIP
This download provides about 20 VBA utility functions for working with the
TypeLib Information object library, which is used to read type libraries.
TypeLib Info is the "engine" behind the VBA Object Browse, and this library
gives you programmatic access to type libraries, allowing you to determine
the various arguments for methods, the symbolic names of constants, the
methods of an object and so on. Complete documentation is in the VBA code of
this workbook. This code is for advanced VBA programmers, not novices. An
advanced version of XLTLI is available for commercial customers.

I suspect if you download that file, you can cook up something to print out
the listing you want.

Regards,
Tom Ogilvy