Error in macro creation

[Guest]

I am new at this. I am trying to create a macro that would execute a
"Sample" found under Tools, Data Analysis. I create the macro using the
record macro method. All seems well until I run it and get a Run-time erroe
'1004':
'ATPVBAEN.XLA' could not be found. Check the spelling... The debug tell me
there is an error in line:"Aplication.Run "ATPVBAEN.XLA!Sample", , , "R", 10,
False.

How do I fix this?
Thank You

 

[Don Guillett]

Install the addin

 

[Guest]

The add-in is installed. I can execute the "sample" manually and it works.
I get the results in the specified output range.

 

[Norman Jones]

Hi Nadeau,

In the VBE (Alt-F11), with the project containing your code module selected:

Tools | References | check atpvbaen.xls