AddIns Method

Applies To

Application Object.

Description

Accessor. Returns an object that represents a single add-in (an AddIn object, Syntax 1) or the collection of add-ins (an AddIns object, Syntax 2) listed in the Add-Ins dialog box. Read-only.

Syntax 1

object.AddIns(index)

Syntax 2

object.AddIns

object

Optional. The Application object.

index

Required for Syntax 1. The number of the add-in, or the title of the add-in, as a string.

Example

This example displays the status of the Analysis ToolPak add-in. Note that the string used as the index to the AddIns method is the Title property of the AddIn object.

If AddIns("Analysis ToolPak").Installed = True Then
    MsgBox "Analysis ToolPak add-in is installed"
Else
    MsgBox "Analysis ToolPak add-in is not installed"
End If