logo ASAP Utilities

Excel tip: Setting a reference to the VBA Extensibility library

Date: 6 september 2001

When your coding the VBE you have to set a reference to the VBA Extensibility library. This can be done manualy, but also with the following code.


Copy-paste friendly code:
Sub MakeLibrary()
' create a reference to the VBA Extensibility library.
      On Error Resume Next            ' in case the reference already exits
      ThisWorkbook.VBProject.References _
                  .AddFromGuid "{0002E157-0000-0000-C000-000000000046}", 5, 0
End Sub



« back

Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years