The secret to using VBA with other applications lies in understanding the object model for each application. VBA, after all, simply manipulates objects, and each product (Excel, Word, Access, PowerPoint, and so forth) has its own unique object model. You can program an application by using the objects that the application exposes.
Excel's object model, for example, exposes several very powerful data analysis objects, such as worksheets, charts, pivot tables, scenarios, and numerous mathematical, financial, engineering, and general business functions. With VBA, you can work with these objects and develop automated procedures. While you work with VBA in Excel, you'll gradually build an understanding of the object model. Warning: It will be very confusing at first. Eventually, however, the pieces will come together — and all of a sudden, you'll realize that you've mastered it!
Was this article helpful?