25Add-Ins

Using VBA, you can create standard add-in files for your clients to use. After the client installs the add-in 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. There are 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 (such as VB6 or ...

Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.