Page 523 - Microsoft Office Excel 2003 Programming Inside Out

Chapter 24

Excel Query Program

Connecting to a Database . . . . . . . . . . 501 Executing a Database Query . . . . . . . . . 508
Editing a Query . . . . . . . . . . . . . . . . . . . 505 Using the Excel Query Program . . . . . . . 515

The Excel Query program developed for this book is a practical application of many of the
tools and techniques that you learned elsewhere in this book. The program can easily be
packaged as an add-in or work as a stand-alone workbook template, plus it combines various
forms and toolbar elements into a cohesive program.

Excel Query Program Overview

The Excel Query program is implemented as an add-in to Microsoft Excel. This add-in lets
you perform database queries and return the results as part of a worksheet. The interface to
the program is through a new command bar, named Excel2k3 VBA Query, and it has four
main components: a drop-down list containing the queries that have been executed, a button
to edit a query, a button to run the query, and a button to configure the database connection.
(See Figure 24-1.)

Figure 24-1. The user interface to the query program is through a new command bar added
to Excel.

497
Part 6: Excel and the Outside World: Collaborating Made Easy