Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - there is an error message pop out during creation. | Charts and Charting in Excel | |||
Error message creation | Excel Discussion (Misc queries) | |||
multiple links creation error | Excel Discussion (Misc queries) | |||
Error '1004' (Method 'Cells' of '_Global' Failed) On chart creation? | Excel Programming | |||
Digital Certificate creation error using makecert | Excel Programming |