Where can I fond documentation listing ALL Excel VBA objects together with
their properties (and property values) and methods (and all their
parameters)

Even though I have access to Excel's Help and a couple of thick Excel VBA
books, this newsgroup frequently contains code snippits using objects, etc.
that I had no idea even existed.

Thanks for any help

"Excel 2007 Developer Reference"
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
In particular, see the "What's New" and "Excel Object Model Reference" sections.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/XLCompanion




wrote in message
...
Where can I fond documentation listing ALL Excel VBA objects together with
their properties (and property values) and methods (and all their
parameters)

Even though I have access to Excel's Help and a couple of thick Excel VBA
books, this newsgroup frequently contains code snippits using objects, etc.
that I had no idea even existed.
Thanks for any help

VBA's help is pretty good.

And if you hit F2 inside the VBE, you'll see the object browser and from there,
you should be able to see the properties and methods.

And if you rightclick on the object browser window, you'll be able to specify
that you want to see the hidden objects, too.



On 07/24/2010 09:16, wrote:
Where can I fond documentation listing ALL Excel VBA objects together with
their properties (and property values) and methods (and all their
parameters)

Even though I have access to Excel's Help and a couple of thick Excel VBA
books, this newsgroup frequently contains code snippits using objects, etc.
that I had no idea even existed.

Thanks for any help

--
Dave Peterson

I don't think there is one single source available for that.

There's Help, Online Help, the Object browser, technical MS references
etc which should be enough to get you through,

I don't really think totally comprehensive source would be that
useful, if it wa even possible to build one.

Also, you can sometimes learn new things when you are searching for
something completely different.:)