invoking add-in function from another add-in or VBA module Thrashman 18.07.2006 03:03:01 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

RE: invoking add-in function from another add-in or VBA module Stephen English 25.07.2006 08:24:01 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" wrote: [Quoted Text] > 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 >

Re: invoking add-in function from another add-in or VBA module Steve Schapel <schapel[ at ]mvps.org.ns> 25.07.2006 19:24:14 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. -- Steve Schapel, Microsoft Access MVP Thrashman wrote: [Quoted Text] > 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 >