Problem accessing networkdays function

[richard.ca]

Hi All,

I seem to be having a problem accessing the networkdays function from VBA
(Excel 2000). Despite having installed the Analysis Toolpak add-in I can't get
networkdays to appear as a method of the Application object. I also tried
Application.WorksheetFunction (I know there were changes between Excel 2000/2003
but can't recall which syntax applies to which version). Alas it doesn't make any
difference.

Anyone any ideas?

Thanks,

Richard.

 

[Andrew Poulsom]

You need to install Analysis Toolpak - VBA (Tools|Add-Ins), and set a reference in your workbook to ATPVBAEN.xla. Then you will be able to use NetWorkdays without qualification - it's not a member of the Application object, but of the Add-In.

 

[richard.ca]

Must be missing something. I installed the Analysis Toolpak as you described and I
already see a reference to ATPVBAEN in my VBA project window but I still get
'function/variable not defined' when I try to call NetWorkdays as in:

MsgBox NetWorkdays(Cells(Target.Row, sdat_col_num), Cells(Target.Row, doby_col_num))

 

[Andrew Poulsom]

You have to add a reference to your workbook. Click your workbook in the project window and choose Tools|References from the menu. Check ATPVBAEN and click OK.

 

[richard.ca]

That did the trick! I was missing the reference.

Thanks a lot Andrew!