Regression

Ubirajara Augusto · 05-31-2005, 09:05 PM

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 · 06-01-2005, 02:05 AM

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

"Ubirajara Augusto" <Ubirajara [email protected]> wrote in
message news:[email protected]...
> 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.

Ubirajara Augusto · 06-01-2005, 08:05 AM

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

"Nigel" escreveu:

> 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
>
>
>
> "Ubirajara Augusto" <Ubirajara [email protected]> wrote in
> message news:[email protected]...
> > 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 · 06-01-2005, 09:05 AM

Use the following addin reference

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

your code

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

--
Cheers
Nigel

"Ubirajara Augusto" <[email protected]> wrote in
message news:[email protected]...
> Thanks but the same message continues to appear.
> Do you have any other tip?
>
> "Nigel" escreveu:
>
> > 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
> >
> >
> >
> > "Ubirajara Augusto" <Ubirajara [email protected]> wrote
in
> > message news:[email protected]...
> > > 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.
> >
> >
> >

Ubirajara Augusto · 06-01-2005, 10:05 AM

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:

> Use the following addin reference
>
> AddIns("Analysis ToolPak - VBA").Installed = True
>
> your code
>
> AddIns("Analysis ToolPak - VBA").Installed = False
>
>
> --
> Cheers
> Nigel
>
>
>
> "Ubirajara Augusto" <[email protected]> wrote in
> message news:[email protected]...
> > Thanks but the same message continues to appear.
> > Do you have any other tip?
> >
> > "Nigel" escreveu:
> >
> > > 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
> > >
> > >
> > >
> > > "Ubirajara Augusto" <Ubirajara [email protected]> wrote
> in
> > > message news:[email protected]...
> > > > 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 · 06-01-2005, 01:05 PM

Try changing the command

ATPVBAEN.XLA!Regression

to

ATPVBAEN.XLA!Regress

--
Cheers
Nigel

"Ubirajara Augusto" <[email protected]> wrote in
message news:[email protected]...
> 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:
>
> > Use the following addin reference
> >
> > AddIns("Analysis ToolPak - VBA").Installed = True
> >
> > your code
> >
> > AddIns("Analysis ToolPak - VBA").Installed = False
> >
> >
> > --
> > Cheers
> > Nigel
> >
> >
> >
> > "Ubirajara Augusto" <[email protected]> wrote
in
> > message news:[email protected]...
> > > Thanks but the same message continues to appear.
> > > Do you have any other tip?
> > >
> > > "Nigel" escreveu:
> > >
> > > > 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
> > > >
> > > >
> > > >
> > > > "Ubirajara Augusto" <Ubirajara [email protected]>
wrote
> > in
> > > > message news:[email protected]...
> > > > > 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.
> > > >
> > > >
> > > >
> >
> >
> >

Ubirajara Augusto · 06-01-2005, 06:05 PM

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

"Nigel" escreveu:

> Try changing the command
>
> ATPVBAEN.XLA!Regression
>
> to
>
> ATPVBAEN.XLA!Regress
>
> --
> Cheers
> Nigel
>
>
>
> "Ubirajara Augusto" <[email protected]> wrote in
> message news:[email protected]...
> > 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:
> >
> > > Use the following addin reference
> > >
> > > AddIns("Analysis ToolPak - VBA").Installed = True
> > >
> > > your code
> > >
> > > AddIns("Analysis ToolPak - VBA").Installed = False
> > >
> > >
> > > --
> > > Cheers
> > > Nigel
> > >
> > >
> > >
> > > "Ubirajara Augusto" <[email protected]> wrote
> in
> > > message news:[email protected]...
> > > > Thanks but the same message continues to appear.
> > > > Do you have any other tip?
> > > >
> > > > "Nigel" escreveu:
> > > >
> > > > > 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
> > > > >
> > > > >
> > > > >
> > > > > "Ubirajara Augusto" <Ubirajara [email protected]>
> wrote
> > > in
> > > > > message news:[email protected]...
> > > > > > 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.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>