MICROSOFT OFFICE ADDIN TYPES

 

Differences

 

Office Addins:

- are written in VBA and can only be edited with the VBA Editor

- are object-based, i.e. only "existing" objects can be used, e.g. Excel Workbook, therefore easy to learn

- are loaded directly via the respective Office product (e.g. Addins folder)

Office Common Addins:

- are compiled bytecode and can only be edited in the source code (which is usually not supplied)

- can be written in all high-level languages (e.g. VB .Net, C etc.)

- can thus be programmed in an object-oriented manner

- are usually loaded via the registry

Similarities

 

- appear in the event of automatic deactivation under ? >> Info >> Deactivated elements

- automate the respective Office product or extend its range of functions