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

T

Thrashman

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
 
S

Stephen English

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

System Error &H8007007E (-2147024770). The specified module could not be found. 0
Autonumber field in Excel that behaves the same as Access 0
Page numbering with Merged Document and IF statements 1
How to call module function or sub from the Add In? 3
Workday Function in VBA 3
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Two columns followed by single page-width column on same page 0
Drop down list control value in vba 2

Top