In the first four parts of this tutorial, we've focused on VBA for Word and Excel. Those two environments are both very widely used and they also represent a standard or "vanilla" hosting environment. In this lesson, we're going to take a look at several different hosting environments and then develop an an example application in one that is sort of "different" - Access.
So ... Let's go into the wider world of VBA and see what else you can do.
The inner circle of the VBA hosting environment includes all of the Office applications. Access, Frontpage, PowerPoint, and Outlook all have VBA environments ... but there aresome very significant differences between them. Of the non-Office applications, Visio, Project and MapPoint also have VBA environments.
It wasn't always this way. A few Microsoft applications have been very late to the VBA party. Outlook 97 and 98, in fact only supported VBscript, not VBA. VBA finally appeared in Outlook 2000 late in the beta testing cycle. Visio was the first "outside" software product to include VBA in 1997 (MS bought Visio a few years after that).
