Edytuj

Udostępnij za pośrednictwem


AddIn Interface

Definition

Represents a single add-in, either installed or not installed.

public interface class AddIn
[System.Runtime.InteropServices.Guid("00020857-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface AddIn
Public Interface AddIn
Attributes

Remarks

The AddIn object is a member of the AddIns collection. The AddIns collection contains a list of all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).

Use AddIns(index), where index is the add-in title or index number, to return a single AddIn object.

Don’t confuse the add-in title, which appears in the Add-Ins dialog box, with the add-in name, which is the file name of the add-in. You must spell the add-in title exactly as it’s spelled in the Add-Ins dialog box, but the capitalization doesn’t have to match.

The index number represents the position of the add-in in the Add-ins available box in the Add-Ins dialog box.

The Add(String, Object) method adds an add-in to the list of available add-ins but doesn’t install the add-in. Set the Installed property of the add-in to True to install the add-in. To install an add-in that doesn’t appear in the list of available add-ins, you must first use the Add method and then set the Installed property. This can be done in a single step

Use Workbooks(index) where index is the add-in filename (not title) to return a reference to the workbook corresponding to a loaded add-in. You must use the file name because loaded add-ins don’t normally appear in the Workbooks collection.

If the Installed property returns True, but calls to functions in the add-in still fail, the add-in may not actually be loaded. This is because the Addin object represents the existence and installed state of the add-in but doesn't represent the actual contents of the add-in workbook. To guarantee that an installed add-in is loaded, you should open the add-in workbook.

Properties

Application

Returns an Application object that represents the Microsoft Excel application.

Author

Reserved for internal use.

CLSID

Returns a read-only unique identifier, or CLSID, identifying an object, as a String.

Comments

Reserved for internal use.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

FullName

Returns the name of the object, including its path on disk, as a string.

Installed

True if the add-in is installed.

IsOpen

Gets whether the add-in is currently open.

Keywords

Reserved for internal use.

Name

Returns the name of the object.

Parent

Returns the parent object for the specified object.

Path

Returns the complete path to the application, excluding the final separator and name of the application.

progID

Returns the programmatic identifiers for the object.

Subject

Reserved for internal use.

Title

Reserved for internal use.

Applies to