XL5: Visual Basic AddIns Method Example Incorrect

ID: Q117661

The information in this article applies to:

SYMPTOMS

In Microsoft Excel 5.0, in Visual Basic Reference Help, the example for the AddIns method returns the following error messages when you run it:

   Run-time error '1004':
   AddIns method of Application class failed

NOTE: Page 42 of the Microsoft Press book "Microsoft Excel 5 Visual Basic for Applications Reference," contains this same example.

CAUSE

This error occurs because the reference to the Solver add-in in the Set statement of the macro is incorrect. The correct name of the Solver add-in is "Solver Add-In."

RESOLUTION

To correct the statement, replace the name "Solver" in the Set statement with the name "Solver Add-In" as in the following example:

   Set currentAddIn = Application.AddIns("Solver Add-In")

REFERENCES

Microsoft Press, "Microsoft Excel 5 Visual Basic for Applications Reference," page 42

Additional query words: 5.00 5.00a 5.00c addin

Version           : WINDOWS: 5.0, 5.0c; MACINTOSH: 5.0, 5.0a
Platform          : MACINTOSH WINDOWS

Last Reviewed: February 4, 1998