Programming Excel with VBA and .NET

Find the Right Object

The hardest part about Excel programming is finding the right object for the job. Excel’s object library is huge and not always easy to understand. One way to tackle that problem is to categorize the objects by task. The chapters later in this book take that approach, as shown by Table 4-4.

Table 4-4. How this book organizes Excel objects by task

Chapter	Description	Covers these objects
7, Controlling Excel	Control Excel’s general options and display and respond to application-level events	Application, AutoCorrect, AutoRecover, ErrorChecking, Windows, and Panes
8, Opening, Saving, and Sharing Workbooks	Access workbooks and their properties and respond to workbook events	Workbook and RecentFile
9, Working with Worksheets and Ranges	Perform general tasks on ranges of cells including inserting values, search and replace, and formatting and respond to worksheet events	Worksheet and Range
10, Linking and Embedding	Add comments, hyperlinks, and various OLE objects to worksheets	Comment, Hyperlink, OLEObject, Speech, and UsedObjects
11, Printing and Publishing	Create hardcopy and online output from workbooks	AutoFilter, Filter, HPageBreak, VPageBreak, PageSetup, Graphic, PublishObject, DefaultWebOptions, and WebOptions
12, Loading and Manipulating Data	Bring data into a workbook from a database or other data source	Parameter and QueryTable ADO objects: Command, Connection, Field, Parameter, and RecordSet ...