| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 analysis toolpak addin | Excel Discussion (Misc queries) | |||
| Analysis ToolPak 2007 does not appear as an available addin. | Excel Discussion (Misc queries) | |||
| Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
| Cannot install Excel 2002 Analysis Addin Toolpak | Excel Programming | |||
| "Reference is not valid" error when using analysis toolpak in an add-in | Excel Programming | |||
Hybrid Mode
