networkdays function

  • Thread starter Thread starter Phil Benthall
  • Start date Start date
P

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