View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 188
Default Create (or find) a complete object tree for excel


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.