Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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.