Regression

[Guest]

I am trying to automate running of regression macros in Excel. I used the
"record" method to create one. But everytime I run the "recorded" regression
macro, I get the error message:

"Macro 'ATPVBAEN.XLA!Regression' could not be found.

Code:

Application.Run "ATPVBAEN.XLA!Regression", ActiveSheet.Range("$B$2:$B$50"), _
ActiveSheet.Range("$A$2:$A$50"), True, True, 95, "AUX44", True,
True, True _
, True, , True

What can I do?

Thanks.

 

[Nigel]

ATPVBAEN.XLA is an add-in, you need to ensure that this is installed before
you run the macro, alternatively change the macro to include this add-in
before the regression command eg

AddIns("Name of Addin").Installed = True

your code to run the analysis using the addin functions

AddIns("Name of Addin").Installed = False

--
Cheers
Nigel

I am trying to automate running of regression macros in Excel. I used the
"record" method to create one. But everytime I run the "recorded" regression
macro, I get the error message:

"Macro 'ATPVBAEN.XLA!Regression' could not be found.

Code:

Application.Run "ATPVBAEN.XLA!Regression",

ActiveSheet.Range("$B$2:$B$50"), _

 

[Guest]

Thanks but the same message continues to appear.
Do you have any other tip?

"Nigel" escreveu:

 

[Nigel]

Use the following addin reference

AddIns("Analysis ToolPak - VBA").Installed = True

your code

AddIns("Analysis ToolPak - VBA").Installed = False

 

[Guest]

That's exactly what I did, but it didn't work.
Do you know if I have to activate any other option in VBA?
Have you ever used the regression library (inside Analysis Toolpack) in VBA?
If you've ever used, could you send me the code / file?

Thank's again.


"Nigel" escreveu:

 

[Nigel]

Try changing the command

ATPVBAEN.XLA!Regression

to

ATPVBAEN.XLA!Regress

 

[Guest]

It's working...
Thank's - it will help me a lot of some work stuff...

"Nigel" escreveu: