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.