AddIns2.Add method (Excel)
Adds a new add-in to the list of add-ins.
Syntax
expression.Add (FileName, CopyFile)
expression A variable that returns an AddIns2 object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
FileName | Required | String | The name of the file that contains the add-in to add to the list in the Add-Ins dialog box. |
CopyFile | Optional | Variant | If the add-in file is on a removable medium, specifies whether to copy the add-in to the local hard disk. Specify True to copy the add-in to your hard disk. Specify False to keep the add-in on the removable medium. If this argument is omitted, Microsoft Excel displays a dialog box and asks the user to choose whether to copy the add-in file. This parameter is ignored if the add-in file is already on the hard disk. |
Return value
AddIn
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.