vbaoutlookms-officeoffice-2007

VBA Extensibility in Outlook


I'd like to write a macro for Outlook 2007 that can add/remove modules in the VBA editor. The VBA Extensibility library looks perfect, but properties like Application.VBE seem to be inaccessible.

In Excel, I would need to enable "Trust access to the VBA project object model". Unfortunately, this option is missing in Outlook 2007.

Does anyone know of a way around this?

Thanks in advance!


Solution

  • I worked around the limitations using SendKeys:

    Not elegant, but good enough.