This chapter reviewed the aspects of VBA that help you get to data existing on a worksheet. VBA is often the best way to automate moving data from a database into a worksheet, and it's always the best way to automate the export of data from Excel to a database. But you have to provide guidance to VBA, and techniques such as For-Next loops, Do While loops, and For Each loops are key to helping VBA locate and move through existing data. Other VBA tools such as With structures and object variables are vital for keeping your code manageable.
Chapter 8, "Opening Databases," complements the material you have read about in this chapter. Here you saw how to use VBA to reach and manipulate data in the worksheet. In Chapter 8, you'll see how to use VBA to reach and manipulate tables in external databases. Chapters 9 through 12 combine this information to show you how to automate two-way communication between Excel workbooks and external databases.
