I was searching for an installer for VSTA (Visual Studio Tools for application). Looks like there is no separate installable for VSTA (Visual Studio Tools for application). After a bit of research, I’ve learnt that VSTA is embedded inside Office 2007 Professional or higher. We can install VSTA by performing the following steps
Control Panel —> Office 2007 — > Change — > Add or remove features
This will display all the Office 2007 suite of products and its corresponding features
Each of the office products like Word, Excel and InfoPath etc has the support for .NET Programmability support. By default the programmability support is not enabled. We need to enable Programmability Support for the relevant products. This would bring the necessary VSTA support for IDE and handles all the application-level events of office. So VSTA becomes the logical replacement for the legacy VBAs.