Create (or find) a complete object tree for excel

[Alan]

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.

 

[Jan Karel Pieterse]

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

 

[Alan]

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.

 

[Jan Karel Pieterse]

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

 

[onedaywhen]

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

http://msdn.microsoft.com/library/d.../off2000/html/xltocobjectmodelapplication.asp

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

--

 

[Alan]

You may find it easier to grab the pics/HTML from the version on MSDN:
http://msdn.microsoft.com/library/d.../off2000/html/xltocobjectmodelapplication.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.