Page 269 - Microsoft Office Excel 2003 Programming Inside Out

Creating Add-Ins and COM Add-Ins

Figure 11-3. Selecting Microsoft Office Excel Add-In (*.xla) as the file type allows you to
save the workbook as an add-in.

Installing the Add-In

Once the add-in has been saved, you can install it by using the Add-Ins dialog box (by choos­
ing Tools, Add-ins from the main menu). When the Add-Ins dialog box is displayed, press the
Browse button to locate your newly created add-in. Place a check mark next to the add-in
name and press OK to include the add-in in the current workbook. (See Figure 11-4.)

Chapter 11

Figure 11-4. Locate your new add-in by looking for the value you specified for the title of the
workbook.
Then you can use it in a cell’s formula like this:

=DiscountedPrice(D2, E2)

243
Part 4: Advanced VBA