帮助获得帮助（数据分析，直方图） [英] help getting help (data analysis, histogram)

问题描述

我遇到的问题让我完全疯了。我想在数据分析工具中使用直方图功能。但我找不到任何文件。谷歌搜索，MSDN搜索，我能找到的最好的东西让我这么远：

Application.Run" ATPVBAEN.XLA！Histogram"，dataRange，""，binRange，False，False，False ，真实

但我不知道第三个参数是什么（"上面"）或任何布尔参数。为什么没有一个简单的地方可以找到参数是什么？由于没有简单的东西告诉我第4个参数是 - 无论是什么，我都非常沮丧。任何和所有帮助都非常感激。

I am having a problem that is driving me completely crazy. I want to use the histogram function in the data analysis tools. But  I can't find any documentation. Google searches, MSDN searches, the best I can find got me this far:

Application.Run "ATPVBAEN.XLA!Histogram", dataRange, "", binRange, False, False, False, True

But I don't know what the 3rd parameter is ("" above), or any of the boolean parameters. Why is there not a simple place to find what the parameters are? I am VERY frustrated by not having something simple that just tells me that the 4th parameter is - whatever it is. Any and all help GREATLY appreciated.

推荐答案

我感觉到你的痛苦 - 我正在寻找，但也没有太多运气。但是我确实在网上找到了一些有用的信息。不是你正在寻找的答案，但不会受到伤害...


当录制使用这些分析工具的宏时，录音机实际上增加了一个"特殊标签"出于某种原因......
"ATPVBAEN.XLA！直方图"给予该过程的标题是无关的，错误的，避免的，错误的！
在VBE中，我删除了"ATVBAEN.XLA"。标题的一部分，并仅保留"直方图"。绰号......还有......瞧！成功......

我会继续关注我是否能找出参数是什么。

I feel your pain - I'm looking but not having much luck either. However I did find a bit of useful information that is all over the net. Not really the answer you’re looking for, but won’t hurt…



When recording a macro that uses these Analysis Tools, the recorder actually adds a "special tag" for some reason...

The "ATPVBAEN.XLA!Histogram" title that is given to the process is extraneous, error, avoid, wrong!!

In VBE, I deleted the "ATVBAEN.XLA" part of the title, and retained only the "histogram" moniker...and ... voila! success...




I'll keep looking to see if I can find out what the parameters are.

这篇关于帮助获得帮助（数据分析，直方图）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！