XL5: Visual Basic AddIns Method Example Incorrect

ID: Q117661

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 5.0, 5.0a

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.00a 5.00c addin

Keywords :
Version : WINDOWS: 5.0, 5.0c; MACINTOSH: 5.0, 5.0a
Platform : MACINTOSH WINDOWS
Issue type :