Reference to analysis toolpak addin

[Guest]

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

 

[Guest]

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

 

[Guest]

Sebastien

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

Thanks