The VBA environment is installed when we install the host application in the computer. The VBA environment is dependent on the host application. When host application runs, the VBA environment is setup and quitting the host application closes the VBA environment associated with it.
It means that we will always have to open a host application to run VBA. Therefore, it is not possible to build a stand-alone applications with VBA, but we can display the user forms created in any Office application by hiding the host application. This creates the illusion of a stand-alone application. The VBA environment runs under the hood and the top environment is that of the host application.
It means that we will always have to open a host application to run VBA. Therefore, it is not possible to build a stand-alone applications with VBA, but we can display the user forms created in any Office application by hiding the host application. This creates the illusion of a stand-alone application. The VBA environment runs under the hood and the top environment is that of the host application.
No comments:
Post a Comment