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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top