Hi All,

I would like to create (or find) a complete object tree for excel.

This seems to be something that I would easily get from MS but I
cannot seem to find it on their site.

Under each object you would see sub-objects, properties, methods, and
events that relate to that object.

I imagine it would look something like this (extract):

Workbook - ActiveChart (Object)
- ...
- Application (Object)
- ...
- Worksheets (Collection)

Under WorkSheets (Collection) you would see (extract):

WorkSheet - Cells (Property)
- ...
- Columns (Property)
- ...
- Range (Object)

Under Range you would then see objects, properties, methods, and
events that relate to that object.


Is this something that is available to download (and print) as a
reference? Obviously there is the object browser and help facility
within the VBE, but I would like to be able to have it in my hands.

Thanks,

Alan.

Hi Alan,

I would like to create (or find) a complete object tree for excel.


Start Help from the VBE,

In the Answer wizard, type "microsoft excel objects" (without the
quotes).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

"Jan Karel Pieterse" wrote in message
...


Start Help from the VBE,

In the Answer wizard, type "microsoft excel objects" (without the
quotes).


Cool - thanks!

Is it possible to get it to print out, in entirety, with everything in
one go?

If not, I can live without a hard copy I guess, but I find it easier
(myself).

Regards,

Alan.

Hi Alan,

Is it possible to get it to print out, in entirety, with everything in
one go?

If not, I can live without a hard copy I guess, but I find it easier
(myself).


No idea.

An excellent book that also contains a very complete overview of all
objects is:

Excel 2000/2002 VBA Programmers Reference. Stephen Bullen, John Green,
Rob Bovey, Robert Rosenberg. Wrox Press.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

You may find it easier to grab the pics/HTML from the version on MSDN:

http://msdn.microsoft.com/library/de...pplication.asp

You'd need to do some reorganizing to accommodate the 'red arrow'
pages. Note this one is Excel2000 version.

--

"Alan" wrote in message ...
"Jan Karel Pieterse" wrote in message
...


Start Help from the VBE,

In the Answer wizard, type "microsoft excel objects" (without the
quotes).


Cool - thanks!

Is it possible to get it to print out, in entirety, with everything in
one go?

If not, I can live without a hard copy I guess, but I find it easier
(myself).

Regards,

Alan.

"onedaywhen" wrote in message
om...

You may find it easier to grab the pics/HTML from the version on
MSDN:


http://msdn.microsoft.com/library/de...pplication.asp

You'd need to do some reorganizing to accommodate the 'red arrow'
pages. Note this one is Excel2000 version.


Thanks - I have printed out the pages I feel are most useful.

I suspect this is something I won't be needing for long, but right now
it feels like I do!

Alan.

"Jan Karel Pieterse" wrote in message
...

An excellent book that also contains a very complete overview of all
objects is:

Excel 2000/2002 VBA Programmers Reference. Stephen Bullen, John
Green, Rob Bovey, Robert Rosenberg. Wrox Press.


Hi Jan,

Thanks for that. I will check it out at my local book store.

Regards,

Alan.