View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snowsride Snowsride is offline
external usenet poster
 
Posts: 20
Default 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