Add Method (AddIns Collection Object)

Applies To

AddIns collection object.

Description

Adds a new add-in file to the list of add-ins in the Add-Ins dialog box (Tools menu). Returns an AddIn object that represents the newly added add-in.

Syntax

expression.Add(Filename)

expression Required. An expression that returns an AddIns object.

Filename Required String. The full name of the file (including the path and file name extension) that contains the add-in you want to add to the list of add-ins.

Remarks

This method doesn't load the new add-in. You must set the Loaded property to load the add-in.

Example

This example adds MyTools.ppa to the list in the Add-Ins dialog box (Tools menu).

Set myAddIn = Application.AddIns.Add("c:\My Documents\Mytools.ppa")
MsgBox myAddIn.Name & " has been added to the list"