Excel tip: Setting a reference to the VBA Extensibility libraryDate: 6 september 2001When 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
Sitemap
Search
List of all utilities
Printer friendly page
Contact Us
^ Back to Top
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |