Looking Ahead
Queries are powerful tools for use in bringing data into an Excel workbook, and they become more powerful yet when you apply parameters to them.
The techniques discussed in Chapter 5, “Using Microsoft Query,” and in this chapter are fine for interactive work—when you're doing something once only, or when you're early in the development process for something that you expect to grow. Those techniques are still used, and used heavily, in more complex situations.
The greater complexity of a solution often depends on the use of coding, and in Office applications that usually starts with VBA. It progresses from there to the use of object libraries that enable VBA to create and execute queries of the sort discussed in Chapters 5 and
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.
