Reference to analysis toolpak addin
 

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

Reference to analysis toolpak addin
 

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

Reference to analysis toolpak addin
 

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