Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts
    In the Excel Options Add-Ins there are two versions of Analysis ToolPak listed: 1) Analysis ToolPak and 2) Analysis ToolPak - VBA. I am using Excel 2007.

    Are there differences between the two versions? Should I install both or just one? I found the files under the Office12\Library\analysis folder and both have the same file creation date 10/26/2006.

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Analysis Toolpack is the one with all the Worksheet Functions that you want.

    Analysis Toolpack VBA is the one for use in Macros.
    Andrew

Posting Permissions

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