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

• Microsoft Excel 97 for Windows

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

REFERENCES

For more information about recording macros, click the Index tab in Microsoft Excel 97 Help, type the following text

  macros, recording