Chapter 24. Excel Query Program

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

Get Microsoft® Office Excel 2003 Programming Inside Out 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.