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

Chapter 7. VBA Essentials Reviewed > Understanding Dot Notation

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 the worksheet where the column, row, or cell is found. Furthermore, if more than one workbook is open when your code runs, you need to specify which workbook you're interested in.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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