ADDIN.MANAGER

Macro Sheets Only

Equivalent to choosing the Add-Ins command from the Tools menu. Adds or removes an add-in from the working set.

Syntax

ADDIN.MANAGER(operation_num, addinname_text, copy_logical)
ADDIN.MANAGER?(operation_num, addinname_text, copy_logical)

Operation_num determines the operation that the add-in manager will perform.

Operation_num Operation

1 Install an add-in, using the descriptive name in the add-in manager dialog.

2 Uninstall an add-in, using the descriptive name in the add-in manager dialog.

3 Adds a new add-in to the list of add-ins that Excel knows about. Equivalent to clicking on the Browse button in the add-in manager and choosing a file. The add-in is not installed by default.

Addinname_text specifies the name of the add-in. If operation_num is 1 or 2, use the descriptive name of the add-in, such as "SOLVER". If operation_num is 3, this contains the filename of the add-in.

Copy_logical specifies whether the add-in should be copied to the library directory. This argument is only used if operation_num is 3. If omitted, and the file is on removable media, the user will be asked if they want to copy it to removable media.

Related Functions

List of Command-Equivalent Functions