Reference to analysis toolpak addin

[Snowsride]

I am creating a custom function that needs to refer to the Weeknum function
that is part of the analysis toolpak addin. How do I make a reference to it?

Thanks

[sebastienm]

I think you need to make a reference to the VBA-Analysis Toolpack (menu Tools
> References) in your project. I believe it is called atpvbaen.xls ('en' may
mean englis here)..
Sebastien

"Snowsride" wrote:

> I am creating a custom function that needs to refer to the Weeknum function
> that is part of the analysis toolpak addin. How do I make a reference to it?
>
> Thanks

[Snowsride]

Sebastien

Thanks - did eventually find it myself after hours of searching!

Thanks

"sebastienm" wrote:

> I think you need to make a reference to the VBA-Analysis Toolpack (menu Tools
> > References) in your project. I believe it is called atpvbaen.xls ('en' may
> mean englis here)..
> Sebastien
>
> "Snowsride" wrote:
>
> > I am creating a custom function that needs to refer to the Weeknum function
> > that is part of the analysis toolpak addin. How do I make a reference to it?
> >
> > Thanks