Extensibility


What is the VBIDE ?

The VBIDE stands for the Visual Basic Integrated Design Environment.
This library is often referred to as the VBIDE object library
This allows you to write code in VBA that reads or modifies other VBA projects, modules, or procedures.


Microsoft Visual Basic for Applications Extensibility 5.3

The VBIDE is the object library that defines all the objects and values that make up VBProject and the Visual Basic Editor. You must reference this library to use the VBA Extensibility objects.
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\ Vbe6ext.olb
(Tools > References)


- Creating a COM Add-in for the Visual Basic Editor


Few Facts

First, you need to set an reference to the VBA Extensibililty library. The library contains the definitions of the objects that make up the VBProject. In the VBA editor, go the the Tools menu and choose References. In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3. If you do not set this reference, you will receive a User-defined type not defined compiler error.
Next, you need to enable programmatic access to the VBA Project. In Excel 2003 and earlier, go the Tools menu (in Excel, not in the VBA editor), choose Macros and then the Security item. In that dialog, click on the Trusted Publishers tab and check the Trust access to the Visual Basic Project setting.
The VBA Project that you are going to change with these procedures must be unlocked. There is no programmatic way to unlock a VBA project (other than using SendKeys). If the project is locked, you must manually unlock. Otherwise, the procedures will not work.




Office 2007 Changes

In Office 2007, click the Developer item on the main Ribbon and then click the Macro Security item in the Code panel.
In that dialog, choose Macro Settings and check the Trust access to the VBA project object model.



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext