Share via

AddIn Method

  • Article

Adds an add-in to the specified spreadsheet.

expression.AddIn(AddIn)

*expression   * An expression that returns a Spreadsheet object.

AddIn    Required Object. Specifies the add-in.

Example

This following example shows you how to add the ATP.dll that is included in the Office Web component to the Spreadsheet object. The example creates a formula in cell A1. The formula that is called is ISEVEN() which returns TRUE if the number supplied is even (for example, ISEVEN(2)) and returns FALSE if the number is odd (for example, ISEVEN(1)).

<object id=calc
 classid="CLSID:0002E559-0000-0000-C000-000000000046">
</object>

<object id=atp
 classid="CLSID:3F98D457-551B-48C5-BDE8-7FDECCD5AFA5">
</object>
 
<SCRIPT language="VBScript">

     Calc.AddIn(atp)
     Calc.range("A1").formula = "=ISEVEN(1)"

</SCRIPT>

Applies to | Spreadsheet Object

See Also | HasAutoMajorUnit Property