Use Excel Add-in functions

[agibsonsw]

Hello. 2003.
In Access VBA, how can I make use of Excel add-in functions, such as
NETWORKDAYS?
Thanks, Andy.

[HansV]

If you want to use workday calculations in Access, you can find a comprehensive series of VBA functions in Date/Time: Doing WorkDay Math in VBA on the Access Web.

It *is* possible to use the Analysis ToolPak functions in Access, but it involves running Excel, which is quite an overhead. Example:

Dim objXL As Object
Set objXL = CreateObject("Excel.Application")
objXL.RegisterXLL objXL.Application.LibraryPath & "\ANALYSIS\ANALYS32.XLL"
Debug.Print objXL.Run("NETWORKDAYS", #7/2/2010#, #7/19/2010#)
objXL.Quit
Set objXL = Nothing

[agibsonsw]

Hello.
Thanks for a very thorough response. Andy.