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
Share this page:
Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook