Chapter 6. The Application Object
Visual Basic for Applications (VBA) uses objects to control Microsoft Excel. Whether you are working with the Excel application (Application object), workbooks (Workbook object), or individual cells (Cell object), you do everything by manipulating an object. All of the objects either contain other objects or are part of a larger object. For example, the Workbook object contains Worksheets objects, which in turn contain Cell objects.
When working with an object, either a property is being set or read, or the object is told to perform an action, called a method. If you wanted to select a worksheet named Sheet2 in the active workbook, you would use the Select method of the Worksheet ...
Get Microsoft® Office Excel 2003 Programming Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
