VBA or Visual Basic for Applications is a small scripting language which can be used in Microsoft applications to automate tasks, extend functionality and more.
Each host application e.g. Word, Excel provides a set of APIs to VBA which the programmer can make use of to interact with said host application and the open document. These programs are typically referred to as macros.
A macro is a small snippet of this VBA code which has been created and stored within a document or file for a host application. This macro can take inputs as well as interact with the user through GUI components and then make changes to a document. Hotkeys can be assigned to launch macros for convenience as well as menus, buttons and events.
Macros can be harmful if run from an untrusted third party source. For more information regarding security concerns read this article.
solved anyone please explain relationship between MS office and VBA? [closed]