|
Regression
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. |
Regression
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 wrote in message ... 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. |
Regression
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 wrote in message ... 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. |
Regression
Use the following addin reference
AddIns("Analysis ToolPak - VBA").Installed = True your code AddIns("Analysis ToolPak - VBA").Installed = False -- Cheers Nigel "Ubirajara Augusto" wrote in message ... 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 wrote in message ... 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. |
Regression
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" wrote in message ... 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 wrote in message ... 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. |
Regression
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" wrote in message ... 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" wrote in message ... 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 wrote in message ... 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. |
| All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com