Page 289 - Microsoft Office Excel 2003 Programming Inside Out

Creating Add-Ins and COM Add-Ins

Pressing the My Button button results in a simple message box that indicates that the My
Button button was clicked.

In this chapter, you learned about add-ins and how you can incorporate them into an Excel
application. Then you learned how to use the Add-Ins dialog box to incorporate an add-in
into Excel. Finally you learned three different techniques to build an add-in: creating a work-
book with a series of Excel macros and saving it as an .xla file; creating an automation add-in
using Visual Basic 6; and creating a COM add-in using Visual Basic .NET. Each of these tech­
niques has its strengths and weaknesses depending on how you plan to incorporate it into
your application.

Chapter 11

263
Part 4: Advanced VBA