Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recordin Regression as a Macro | New Users to Excel | |||
calling a macro | Excel Programming | |||
Problem seting-up Regression Macro | Excel Discussion (Misc queries) | |||
Calling a macro from a key | Excel Programming | |||
Looking for a macro to curve fit using multiple regression | Excel Programming |