invoking add-in function from another add-in or VBA module

[Guest]

I have a VBA module and want to use the =WORKDAY function, which is part of
the analysis toolpack add-in. When I try to use the VBA statement
application.worksheetfunction.workday(... it can't find the function.
How do I specify the add-in to find the workday (or other) function which is
part of an add-in? I'm using Office 2003 but would like the solution to work
under Excel 2000 or better.

thanks

 

[Guest]

FRom the code module go to Tools - References and I think you have to add a
reference like you clicked the box in Tools - Addins
Your challenge is to find the right one!
I looked and it is not obvious!
Stephen

 

[Steve Schapel]

Thrashman,

The focus of this newsgroup is macros in Access, the database product.
It appears your question may be related to Excel, and as such you will
have a better chance of a good response in an Excel-related newsgroup.