User FAQs

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 can use Compilation Constants

#If VBA7 Then 
#Else
#EndIf

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.


5) Can I write VBA code using VS Code ?
There are some extensions that can be used.

link - marketplace.visualstudio.com/search?term=VBA&target=VSCode&category=All%20categories&sortBy=Relevance 
link - marketplace.visualstudio.com/items?itemName=serkonda7.vscode-vba
link - marketplace.visualstudio.com/items?itemName=spences10.VBA

6) Do the OpenDocument Formats support VBA ?
None of the OpenDocument formats support VBA code
Excel - OpenDocument Spreadsheet (ODS)
Word - OpenDocument Text (ODT)
PowerPoint - OpenDocument Presentation (ODP)


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext