| Microsoft Office 2000/Visual Basic Programmer's Guide | |
An Excel wizard is simply a template or add-in. There's no special file format that indicates that an Excel file is a wizard. To create an Excel wizard, follow the guidelines discussed in "Excel Templates" and "Excel Add-ins" earlier in this chapter.
The List Box/Combo Box Wizard, available as ListComboWiz.xla in the ODETools\V9\Samples\OPG\Samples\CH11 subfolder on the Office 2000 Developer CD-ROM, is a good example of an Excel wizard. This add-in guides users through the process of creating a list box or combo box on an Excel worksheet based on a table in an Access database.