AddIns.Add Method
Excel Developer Reference |
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 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 (a floppy disk or 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.
Visual Basic for Applications |
---|
|
See Also