Learning about VBA libraries
VBA in its native format in all of the MS Office suite of applications provides the most common functionality you will use in your applications, but it does not provide everything; otherwise, it would be large and unwieldy. For this reason, specific functionality is available in library files that can be shared and used by VBA. You add a reference when you require the library, which then makes its functions available to your code. These library packs are offered by Microsoft and third-party vendors, or you can create your own library files of functions you want to share with your application. Library files are created in languages such as C# and Visual Basic 6 (VB6) and are compiled so that their code is not available to view or edit, thus protecting the logic built into them.
The most common library file extensions are listed here:
- Dynamic-linked library (DLL)
- Object Linking and Embedding Type Library (OLE TLB)
- Active X controls (OCX...
