Calling Regression Toolpack in a Macro
I want to call the Regression capability in Excel's Data Analysis Tool Pack
from a VBA macro. I have checked atpvbaen.xls in the Reference pulldown menu item in the macro and Tool Pack VBA in Add-ins. The call syntax begins with Application.Run "ATPVBEAN.XLA!Regress" , but how do I find what the remaining parameters are to include in the call, including specifying the input and output ranges? Thanks for your help Phil |
Calling Regression Toolpack in a Macro
Record a macro while you use the ATP menu system to call the regression tool.
Then examine the recorded syntax. Depending on what you want, it may be simpler to use LINEST, which is the fundamental calculation engine underneath the ATP regression tool. Jerry "Phil" wrote: I want to call the Regression capability in Excel's Data Analysis Tool Pack from a VBA macro. I have checked atpvbaen.xls in the Reference pulldown menu item in the macro and Tool Pack VBA in Add-ins. The call syntax begins with Application.Run "ATPVBEAN.XLA!Regress" , but how do I find what the remaining parameters are to include in the call, including specifying the input and output ranges? Thanks for your help Phil |
All times are GMT +1. The time now is 03:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com