Managing Data with Microsoft® Excel

Understanding Dot Notation

This chapter's first section mentioned that the Excel object model is a hierarchy. For example, one object near the top of the hierarchy is the workbook. Workbooks have worksheets that belong to them. In turn, worksheets have rows and columns and cells. (Worksheets have many other objects as well. This book focuses on objects that are important for data management, and the Comment object, for example, isn't critical to managing data.)

In the course of moving data to a database from a worksheet, or to a worksheet from a database, you always need to direct attention to the particular column, row, or cell from which you want to get data or to which you want to write it. And that requirement implies that you need to specify ...