• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Taking Control of Excel with... > Understanding Excel's Object Model

Understanding Excel's Object Model

Of all the Office applications, Excel was the first to support VBA and object models. This concept was introduced to Excel programmers in Excel 5, and has been further developed in Excel for Windows 95 (version 7), and now has been updated for Excel 97 (version 8). Excel's object model is very extensive, and might even seem a little overwhelming at first. Remember, the object model contains references to all the features of Excel, and Excel 97 is certainly a feature-rich program. Additionally, as you will see in this chapter, there are objects designed specifically for VBA programmers, such as the Range object. There is no way to take advantage of this object without programming, and, as you will see, it gives you lots of added power in your VBA applications.

No macro developer should expect to memorize the entire Excel 97 object model. You will get to know those objects that you use frequently very well, but you'll need help with others. Even frequently used objects will have many features that you use only occasionally, so you'll need help with them, too. There are a few things to remember in beginning to learn the Excel object model, to keep you from losing your way in this rich and extensive model:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint