Edit

Share via


AddIns.Add method (Excel)

Adds a new add-in file to the list of add-ins. Returns an AddIn object.

Syntax

expression.Add (FileName, CopyFile)

expression A variable that represents an AddIns object.

Parameters

Name Required/Optional Data type Description
FileName Required String The name of the file that contains the add-in or the ProgID of the automation add-in that you want to add to the list in the add-in manager.
CopyFile Optional Variant Ignored if the add-in file is on a hard disk. True to copy the add-in to your hard disk, if the add-in is on a removable medium (such as a compact disc). False to have the add-in remain on the removable medium. If this argument is omitted, Microsoft Excel displays a dialog box and asks you to choose.

Return value

An AddIn object that represents the new add-in.

Remarks

This method does not install the new add-in. You must set the Installed property to install the add-in.

Example

This example inserts the add-in Myaddin.xla from drive A. When you run this example, Microsoft Excel copies the file A:\Myaddin.xla to the Library folder on your hard disk and adds the add-in title to the list in the Add-Ins dialog box.

Sub UseAddIn() 
 
 Set myAddIn = AddIns.Add(Filename:="A:\MYADDIN.XLA", _ 
 CopyFile:=True) 
 MsgBox myAddIn.Title & " has been added to the list" 
 
End Sub

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.