networkdays function

[Phil Benthall]

Please help. I am trying to use the networkdays function
in a query in Access 2000 (Office 2000) but I get
a "#Name" error. Help tels me that I am missing a DLL.
When I check the Office directory it's there. When I use
this function in Excell it works. I'm lost. According to
Access it's not installed. According to Excell it is. What
can I do?

 

[Ken Snell]

I believe that NetWorkDays is a worksheet function in EXCEL. ACCESS does not
natively incorporate EXCEL worksheet functions. You can use them if you set
references in ACCESS to the EXCEL library and then preface them with (I
believe)
Excel.Application.nameofworksheetfunction