View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nadeau Poultry Nadeau Poultry is offline
external usenet poster
 
Posts: 2
Default 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