Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Analysis ToolPak - VBA arguments for Histogram (2003 SP3)

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> Would it be too hard for Microsoft to provide some useful instructions about statements and their arguments???!!!!

    Where, if anywhere, does Microsoft keep instructions about the parameter arguments for the various Analysis Tools in Analysis ToolPak? Specifically, for the VBA file, atpvbaen.xla, the Histogram analysis tool, I want to know what the 4th through 7th arguments are, and what their acceptable values are. I looked on MSDN. I certainly looked on Excel and Excel VBA help screens.

    It's easy to figure out the first three arguments. My example:
    Application.Run "ATPVBAEN.XLA!Histogram", _
    ActiveWorkbook.Names("Histo_Data").RefersToRange, _
    Sheets("Analy Histo").Range("$F$1"), _
    Sheets("Analy Histo").[$E$2:$E$28], _
    False, False, False, False
    ...but the last four are undefined and untaught. I guess that they relate to the blank text boxes/address boxes in the Histogram dialog box; those are: Labels, Pareto, Cumulative Percentage, Chart Output. Are we just supposed to do trial-and-error, until we find the correct sequence for these? That's 24 possibilities, if I'm not mistaken!

    Then, multiply my question about the Histogram tool by the total number of analysis tools; surely, there is a guideline or two, hiding away somewhere in the bowels of Microsoft?

    Thanks. <img src=/S/read.gif border=0 alt=read width=19 height=33>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Analysis ToolPak - VBA arguments for Histogram (2003 SP3)

    If you set a reference in the Visual Basic Editor to atpvbaen.xls, the Analysus ToolPak VBA functions will be documented in the Object Browser (press F2 to activate it). Still no help, but at least you'll know the names and order of the arguments...

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Re: Analysis ToolPak - VBA arguments for Histogram (2003 SP3)

    Hans:
    You answered the most important part of what I was asking. Many thanks!
    John S.

Posting Permissions

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