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

Object Models and VBA

Most of the real work that an Excel macro performs involves the use of the Excel 97 object model. The actions in a recorded macro are mostly the result of executing the methods and modifying the properties of the built-in objects. When you write your own VBA code, you need a thorough understanding of the object model of Excel to select the best course of action for your code.

By incorporating the use of object models into the VBA development environment, VBA is able to use a relatively simple, consistent language that can work with any application. (The core elements of VBA were presented in Chapter 29, "Introducing VBA Programming.") Of course, the recorded macros and other examples in that chapter made use of the Excel object model, but the detailed description of objects was saved for this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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