Results 1 to 13 of 13
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How can i get to the excel object model? My vbe search does not find it? Are there any good web references that show this in detail?

    [attachment=84750:excel_object_model.GIF]
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try searching for excel objects.

    Or see Microsoft Excel Objects; it's for Excel 2002 but the differences with Excel 2003 are small.

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Everything in my vbe search relates to office, but not excel. I have a full installation AFAIK, so do not understand why I cannot get to the excel help files. I'll keep looking....

    Thanks for the link.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you get (relevant) help if you type an Excel VBA keyword such as worksheet or range in a module or in the Immediate window and press the F1 key?

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, I do. The help files appear to be intact.

    I was following p.54 of the excel vba programming for dummies (I must move on from here ) which states:

    Activate the VBE
    Type object model in the help box (located to the right of the menu bar)
    The search results appear in the task pane
    Click Microsoft Excel Object Model
    You see the diagram shown here

    But no cigar.

    I can get to the Office o/m, but not excel.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The help function in Microsoft Office becomes worse with each new version, but I don't understand why you can't find the Excel object model.

    You should be able to use the online one for Excel 2002 that I posted a link to.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If I type Microsoft excel object model it comes up as the third choice. (Excel 2003)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Also using 2003..... but no.

    [attachment=84753:excel_ob..._model_2.GIF]
    Attached Images Attached Images

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If I select Help, Microsoft Visual Basic help from the menu, the first entry on the task pane is also the object model.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    For me too:
    [attachment=84757:x.png]
    Attached Images Attached Images
    • File Type: png x.png (6.8 KB, 0 views)

  11. #11
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yee ha, Thanks...

    [attachment=84758:excel_ob..._model_3.GIF]
    Attached Images Attached Images

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I still find it odd that your results differ so much from ours though. Oh well, this again proves how terrible Office Help has become.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='785373' date='20-Jul-2009 11:19']Oh well, this again proves how terrible Office Help has become.[/quote]

    Which is why I spend so much time here, and so little time there

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •