XL5: Visual Basic AddIns Method Example Incorrect

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

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


Last Reviewed: August 31, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.