Hello group,

how can I call statistic funtions from vba (Histogramm)?

On Dec 6, 9:59 am, iwl <Ingo.W...@gmx.de> wrote:
> Hello group,
>
> how can I call statistic funtions from vba (Histogramm)?

Use WorkSheetFunctio. (dot) and select the available function.

Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.

SteveM

On 6 Dez., 16:16, SteveM <sbm...@vzavenue.net> wrote:
> On Dec 6, 9:59 am, iwl <Ingo.W...@gmx.de> wrote:
>
> > Hello group,
>
> > how can I call statistic funtions from vba (Histogramm)?
>
> Use WorkSheetFunctio. (dot) and select the available function.
>
> Although the Histogram is not a standard function. So you'll have to
> track creation with the Macro recorder and then modify the code for it
> to do what you want in VBA.
>
Hi,

found it out up to that point up to now.
But when I try to call this macro or use it from vba I allways get
errors, don't found the according xla file, don't found the macro
I have clicked all references in excel and vba to the analysis file
nothing helps, many peaople seems to have problems with calling
the analysis functions from macros / vba.

On 6 Dez., 17:34, iwl <Ingo.W...@gmx.de> wrote:
> On 6 Dez., 16:16, SteveM <sbm...@vzavenue.net> wrote:> On Dec 6, 9:59 am, iwl <Ingo.W...@gmx.de> wrote:
>
> > > Hello group,
>
> > > how can I call statistic funtions from vba (Histogramm)?
>
> > Use WorkSheetFunctio. (dot) and select the available function.
>
> > Although the Histogram is not a standard function. So you'll have to
> > track creation with the Macro recorder and then modify the code for it
> > to do what you want in VBA.
>
> Hi,
>
> found it out up to that point up to now.
> But when I try to call this macro or use it from vba I allways get
> errors, don't found the according xla file, don't found the macro
> I have clicked all references in excel and vba to the analysis file
> nothing helps, many peaople seems to have problems with calling
> the analysis functions from macros / vba.

There Seems to be a problem with the German
atpvbaen/de file it does not work for some reason.
I had to setup a new link in the vba references pointing to the
english
atpvbaen.xla file and now can use the english version of the command
(histogram)