Erlandsen Data ConsultingAn addin is a workbook with custom commands and functions that can be used with Excel. Addin’s are used to distribute macros, userdefined functions or custom solutions to other users. If the addin contains VBA code that refers to the workbook running the code you have to use the object ThisWorkbook instead of ActiveWorkbook. An [...]
The source code in an addin is poorly protected against users that are determined to take a look at it. There are both (almost) free tools and commercial tools available that can “decompile” the addins (for all Office-applications). If you need one you only have to search the Internet. Maybe the source code protection is [...]
Describe the contents of the addin workbook Select File, Properties Select Summary. In the field Comments you can add a description of the addin workbook contents. This description will be displayed in the Addin Manager dialogbox when the user selects the addin. Statusbar information The statusbar can display a description text that informs the user [...]
Addins in Excel97 are saved differently from the previous versions of Excel: Start the Visual Basic Editor by pressing Alt+F11. Select Debug, Compile VBA projectname. In previous versions of Excel the VBA-code was automatically compiled when you saved the addin. This is no longer true, you have to do it yourself before you save the [...]
Earlier versions of Office had 9 different add-in models. All of these models had different attributes for startup, shutdown, registering, behaviour, language and communication between applications. This is now history, a COM Add-In has full access to the objectmodels in Office. What can a COM Add-In do? All objectmodels are available for you as a [...]