Microsoft KB Archive/171027

= XL97: "Run-Time Error '1004': ATPVBAEN.XLA Could Not Be Found" =

Article ID: 171027

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q171027



SYMPTOMS
If you run a macro that uses a function from the Analysis ToolPak add-in, you receive the following error message:

Run-time error '1004':

'ATPVBAEN.XLA' could not be found. Check the spelling of the file name, and verify that the file location is correct.



CAUSE
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.



WORKAROUND
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.



MORE INFORMATION
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! " command. In Microsoft Excel 97, the Analysis ToolPak - VBA add-in must be loaded to run the recorded macro.

