These two products and their object models have everything I could possibly need for developing a robust enterprise application. Plus I m not even including that smorgasbord of goodies that comes with Visual Studio 6 for developing applications. Years ago we had to develop our own library of tools just to access a database or develop a data entry screen. But I can feel secure that if there is a VBA enabled application that the client owns on their desktop there is more than likely an Object Model loaded with all the tools I need. Plus the client has already licensed it.
Lets run the numbers.
In Microsoft Office 97 alone there are more than ten application specific object models. The eight larger ones total some 644 Objects with over 12,304 Properties and Methods for us to use. Descriptions of some of them are as follows. We all learned database access in VB with it. It has ONLY 37 Objects and 409 Properties and Methods in it.