To fully qualify an identifier's name include the library of origin. If the name is not fully qualified, VBA will not know which identifier is being referred to and errors can occur. There are times when a library contains an identifier that is the same as another identifier in VBA or another library. When using libraries, be sure to use the fully qualified names for classes, variables, and procedures to avoid naming collisions. Early-binding vs late-binding is discussed in the Objects section. Members of a library can be accessed without a reference by using late-binding (declaring an object variable with the generic Object type and using the CreateObject function with the class's ProgID). To set a reference to a library navigate to Tools → References in the Visual Basic Editor and check the library and click Ok. Setting a reference allows for early-binding of object variables, enables intellisense, and makes the library visible in the Object Browser. Setting a reference allows the VBA compiler and the Visual Basic Editor to see the members of a library. Setting a reference to a library allows a VBA project to access the members of the library directly.
Libraries can be used to write VBA programs that utilize multiple applications, access the user's file system, manipulate text files and databases, get information from the internet, and more.
Libraries are often used to control a specific application or access classes which serve specific purposes.
#MICROSOFT VISUAL BASIC FOR APPLICATIONS EXTENSIBILITY 5.3 SOFTWARE#
There are a number of VBA libraries provided by the Windows operating system, Office applications, and other software installed by the user.
Libraries are used to access functionality outside of what VBA can do on its own.
0 kommentar(er)
