Looking Ahead
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 ...
Get Managing Data with Microsoft® Excel 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.
