CHAPTER 16
Creating and Using Add-Ins
What Is an Add-In?
One of Excel's most useful features for developers is the capability to create add-ins. Creating add-ins adds a professional touch to your work, and add-ins offer several key advantages over standard workbook files.
Generally speaking, a spreadsheet add-in is something added to a spreadsheet application to give it additional functionality. Excel ships with several add-ins. Examples include the Analysis ToolPak (which adds statistical and analysis capabilities) and Solver (which performs advanced optimization calculations).
Some add-ins also provide new worksheet functions that you can use in formulas. With a well-designed add-in, the new features blend in well with the original...