The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you run a Visual Basic procedure that contains an Analysis ToolPak function, you may receive the following error message where FUNCTION is the name of the function that you used in the procedure. In Microsoft Excel for the Macintosh, the first time you run the procedure that contains an Analysis ToolPak function, you may receive the following error message: When you run the macro a second time, you may receive the following error message
CAUSE
This problem occurs if the Analysis ToolPak-Visual Basic for Applications
add-in file (ATPVBAEN.XLA in Windows, Analysis ToolPak-Visual Basic for
Applications on the Macintosh) is not open when you run the procedure that
contains the Analysis ToolPak function.
WORKAROUNDTo work around this behavior, use either of the following methods. Method 1Open the Analysis ToolPak-Visual Basic for Applications add-in file before you run a procedure that contains an Analysis ToolPak Visual Basic for Applications function. In Microsoft Excel for Windows, open ATPVBAEN.XLA located in the LIBRARY\ANALYSIS subdirectory of the Microsoft Excel directory. In Microsoft Excel for the Macintosh, open the Analysis ToolPak- Visual Basic for Applications file located in the Microsoft Excel:Macro Library:Analysis Tools folder.Method 2Load the Analysis ToolPak-Visual Basic for Applications add-in before you run a procedure that contains an Analysis ToolPak - Visual Basic for Applications function by using these steps:
MORE INFORMATIONTo view the Visual Basic functions that are included in the Analysis ToolPakVisual Basic for Applications add-in, use the following appropriate steps. Microsoft Excel for Windows
Microsoft Excel for the Macintosh
Additional query words: addins ATP
Keywords : kbcode kbprg kbtool |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |