Microsoft KB Archive/171027
Article ID: 171027
Article Last Modified on 10/11/2006
- Microsoft Excel 97 Standard Edition
This article was previously published under Q171027
If you run a macro that uses a function from the Analysis ToolPak add-in, you receive the following error message:
This problem occurs if you run a Microsoft Visual Basic for Applications macro that uses a function from the Analysis ToolPak add-in and the Analysis ToolPak VBA add-in is not loaded.
If you use recorded macro code that uses a function in the Analysis ToolPak, select the Analysis ToolPak - VBA add-in before you run the macro code.
In earlier versions of Microsoft Excel, recorded macro code that uses a function in the Analysis ToolPak uses the Microsoft Excel 4.0
ExecuteExcel4Macro macro command. In Microsoft Excel 97, the recorded code uses the Application.Run "Atpvbaen.xla!<function>" command. In Microsoft Excel 97, the Analysis ToolPak - VBA add-in must be loaded to run the recorded macro.
For more information about recording macros, click the Index tab in Microsoft Excel 97 Help, type the following text
and then double-click the selected text to go to the "Record a macro" topic.
Additional query words: XL97 8.00 vba atp analysis toolpak toolpack
Keywords: kbdtacode kberrmsg kbprb kbprogramming KB171027