Where oh where is the Excel 2010 Object Model diagram? I expected to find it linked from here:
but no luck.
I'm looking for something like the one with nice formatting and working links in the dev help file for Excel 2003:
Or like the 2007 was supposed to be if it wasn't rendered useless by its broken formatting:
http://msdn.microsoft.com/en-us/library/bb332345%28v=office.12%29.aspxA proper Object Model diagram is possibly the single most useful piece of doc for Excel programmers, not least because in a number of cases collections have untyped items, so it's not possible to work out from the library what the intended hierarchy is.
I'm really hoping there's one for 2010 somewhere.
Are you looking for the hierarchy of the Excel object model? Here it is:
And here is the list of object model of Excel 2010
For more, a sample code for how to iterate over all the sheets in a workbook: http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/00daf939-2e23-424b-b8de-bb10de4d6614
Best Regards, Calvin Gao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Sorry about the very long pause on this topic -- emergency events intervened.
Anyhow, I unmarked your response as The Answer because although it was helpful (thanks) it is only the very smallest part of the object model, not the full picture like what was available for 2003, and what would be available for 2007 if the formatting didn't make it useless.
So, still hoping to either discover the real object model diagram, or prompt someone to produce it!