+ Reply to Thread
Results 1 to 2 of 2

Calling Regression Toolpack in a Macro

  1. #1
    Phil
    Guest

    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. #2
    Jerry W. Lewis
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1