Results 1 to 2 of 2
  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 (Excel 2000/Sr1)

    Anyone have information or examples of using the Excel object model to automate accessing the VBE of an Excel template or workbook? 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
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

    Check out the code in Chip Pearson's site to help get you started:
    http://www.cpearson.com/excel/vbe.htm

    It describes some of the objects, methods, and properties of the VBE that you can manipulate from VBA.

    Steve

Posting Permissions

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