Error in macro creation
 

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

Error in macro creation
 

Install the addin

--
Don Guillett
SalesAid Software

"Nadeau Poultry" wrote in message
...
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

Error in macro creation
 

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

"Don Guillett" wrote:

Install the addin

--
Don Guillett
SalesAid Software

"Nadeau Poultry" wrote in message
...
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

Error in macro creation
 

Hi Nadeau,

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

Tools | References | check atpvbaen.xls

---
Regards,
Norman



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

"Don Guillett" wrote:

Install the addin

--
Don Guillett
SalesAid Software

"Nadeau Poultry" wrote in
message
...
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