MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Looking for a topological map of VBA object/classes, methods, function

  Asked By: Joel    Date: Sep 22    Category: MS Office    Views: 2773

I am looking for a graphic presentation of the classes, methods, etc.,
that make up VBA for Excel. I have not yet found a book or a poster or
an online resource that shows me the relationships between the objects.

Since I am returning to programming after 20 years of business
development, I am quite surprised that these developer support documents
are so hard to find.



6 Answers Found

Answer #1    Answered By: Bobbie Gonzalez     Answered On: Sep 22

in the vba  help in excel  you can find  the excel object model.. shows  the
hierarchy of the different objects.. as for classes  and methods  there are
links on the model that you click on to get the help page on that part...

Answer #2    Answered By: Jerrah Brown     Answered On: Sep 22

This definitely helps, but it is nowhere near as good as having a
large poster on the wall. I've seen this kind of thing in other
OOPLs, like Java, but not for VBA.


Answer #3    Answered By: Brandeis Fischer     Answered On: Sep 22

The object model was supplied as a chart with the Developers edition of Office

It is on line for Excel 2003 at

Answer #4    Answered By: Hadeel Khan     Answered On: Sep 22

I may have not followed the right protocol in my past message, but
what I thought I had posted was:

As for a visual or a poster of the hierarchy, I haven't seen one
either, so maybe we need to develop one.

Answer #5    Answered By: Alice Hughes     Answered On: Sep 22

Maybe so. Would there be enough interest out there? If so, an easy
business case could be made (I'm a bus. guy, remember?), and having
been a publisher in the early days of QuickTime, the production and
distribution is fairly easy.

Answer #6    Answered By: Tyrell Thompson     Answered On: Sep 22

Microsoft does have a large collection of posters, including the object
models. The trick is finding them. Does the word "poster" mean something you
hang on your wall or a person who posts a question to a newsgroup.(*1)
Almost as much fun as trying to find  something on "Word" (the application).