If you have a question, please send it to us.
1) What is a type library and why would you use one ?
A type library is a file that contains a detailed description of an external component.
It contains information about all the objects, methods, properties and constants.
It must be referenced if you want to have Early Binding to the exposed object.
2) How would you add a type library to your project ?
You can add a type library using the (Tools > References) dialog box.
References to other application object models or type libraries can be added to allow their objects to be accessible from VBA.
3) How would you implement a feature switch in VBA ?
You would you Compilation Constants.
#If VBA7 Then
4) When I save the file the "lock project for viewing" option is not saved.
You must actually have some VBA code in the project to be able to lock the project.
If no VBA code has been added the project will always stay open.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext