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

Looking Ahead

This chapter builds on a foundation begun in Chapter 7. That foundation puts you in a position to use VBA in conjunction with Excel to connect to external databases.

VBA and Excel can't connect to databases without help, though. You need to provide them with an object library, one that contains information about the objects, properties, and methods found in a database. ADO and DAO are two such object libraries, and this chapter has shown you how to integrate them with your VBA code, and how to open databases by applying references to the libraries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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