Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using VBA to access the VBE (2000/SR1)

    Anyone have information or examples of using the Excel object model to automate accessing the VBE of an Word template or document? I have coded some to it but keep running into such problems as navigating the different folders of a template project such as forms, modules, classes. Also I am not sure how to navigate the various projects that might be loaded such as when addins are loaded as well. How about getting passed a project's password or if there is a dialog that popups for example due to an error loading an addin.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using VBA to access the VBE (2000/SR1)

    Accessing the VBE of a Word document or template has nothing to do with the Excel object model.

    To manipulate modules in code, you must set a reference (Tools | References...) to Microsoft Visual Basic for Applications Extensibiility 5.3 (the latter is the version on my Office XP installation). Once you have done so, look up items like VBE, VBProject and VBComponent in the Object Browser and in the online help.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using VBA to access the VBE (2000/SR1)

    Yea that was just a poor choiced of words saying Excel object model just me being focused trying to access those Excel objects.

Posting Permissions

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