View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Modelling Object Models

John,
If you mean in code to loop through the properties, methods etc, basically
you can't.
There may be components that can examine the type library and present them
in some way like that, but natively, it's not supported.

If you mean to research/learn the object model, the Object Browser will show
you all available. And help has a section on the hierarchy of objects.
There's also app like Type Library Explorer that may be useful.

NickHK

"John" bl...
Hi there,

Can anyone tell me how to go about modelling an Office object model.

The part I'm not sure of is how to iterate through the objects and methods
etc.

Would you start with looping through the Application object and then go
from there and if so how would you get hold of the various names of those
objects and methods?

Best regards

John