microsoft visual basic for applications core

Therefore, Excel is like the TV, and your VBA project is like the remote control for manipulating the properties of that TV.

Most of the time when you’re programming in VBA, your macros are interacting with the host and the objects provided by the host.įor example, your macros work with the Excel application and control the objects provided by Excel, such as Worksheets, Cells, or pivot tables. If you want to share or distribute your VBA macros, the other party must also have Microsoft Office installed. On the other hand, VBA macros cannot be compiled into stand-alone applications and must be run from within a host application (Word, Excel, etc.). the file with an extension “.EXE”) You can think of such self-contained, standalone application as a television with all the features you want. Normally, it is an application which you can run by double-clicking the file. In Visual Basic, after writing the code, you can then compile it into an executable application. Standalone Application vs Run Within a Host – TV vs Remote (The classic version of Visual Basic is VB6.) They also share the same programming concept of objects, methods and properties.Ī lot of code written in VB can be directly applied in VBA with no (or minor) modification.Īlso, you can think of the languages (both VB and VBA) as Basic plus a “visual” layer which allows developers to create user friendly user forms and controls for users to interact with the program. Visual Basic for Applications was developed based on Visual Basic, and therefore they have the same language structure and share the same set of core vocabularies. End User Developed Application (EUDA) and IT Management.VB is Windows only VBA supports both Windows and Apple Mac.

VBA is Free and Does Not Require Additional Installation.

Standalone Application vs Run Within a Host – TV vs Remote.

Microsoft visual basic for applications core