Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 27. Creating Add-Ins

IN THIS CHAPTER

Characteristics of Standard Add-Ins	569
Converting an Excel Workbook to an Add-In	570
Having Your Client Install the Add-In	572
Using a Hidden Workbook as an Alternative to an Add-In	575
Using a Hidden Code Workbook to Hold All Macros and Forms	575
Next Steps	576

Using VBA, you can create standard add-in files for your clients to use. After the client installs the addin on his PC, the program will be available to Excel and loads automatically every time he opens Excel.

This chapter discusses standard add-ins. Be aware that there are two other kinds of add-ins: COM add-ins and DLL add-ins. Neither of these can be created with VBA. To create these types of add-ins, you need either Visual Basic.NET or Visual C++. ...