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 6.

To get to that point, you need to know something about VBA. In the next chapter, this book departs briefly from its main theme of data management so as to familiarize you, or perhaps remind you, of some of the fundamental aspects of VBA that you'll need to automate a workbook's relationship with external data sources.



Managing Data with Microsoft Excel
Managing Data with Microsoft Excel
ISBN: 789731002
EAN: N/A
Year: 2003
Pages: 134

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net