Chapter 21: Creating and Using Add-Ins

 Download CD Content

Overview

In This Chapter

In this chapter, I explain the benefits of using add-ins, and I show you how to create your own add-ins by using only the tools built into Excel.

• An overview of add-ins and why this concept is important for developers

• Details about Excel's Add-In Manager

• How to create an add-in, including a hands-on example

• How XLSA add-in files differ from XLSM files

• Examples of VBA code that manipulates add-ins

• How to detect whether an add-in is installed properly

One of Excel's most useful features for developers is the ability to create addins. Creating add-ins adds a professional touch to your work and, as you'll see, add-ins offer several key advantages over standard workbook files.