how to use workdays or networkdays in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ABG - 23 Mar 2006 04:26 GMT

I have a macro that needs either Workdays or networkdays to determine the
number of workdays in a month.
I have installed the "Analysis Tool Pack" and "Analysis Took Pack - VBA"
into Excel.
I am trying to use "application.worksheetfunction.networkdays(.....)"
however after I enter the "." there is no reference to either "Workdays" or
"Networkdays" from the object browser.

When I run the macro, it errors out with Run-time error 438 - Object does
not support this property or method.

Does anyone know why this is happening, and what I can do to correct this?

Thank-you

Reply to this Message

Ron Rosenfeld - 23 Mar 2006 04:48 GMT

>I have a macro that needs either Workdays or networkdays to determine the
>number of workdays in a month.
[quoted text clipped - 10 lines]
>
>Thank-you

In the VB editor, Tools/References atpvbaen.xls

Then in your macro, just use:

Var = workdays(dt,num)

--ron

Reply to this Message

ABG - 23 Mar 2006 05:01 GMT

THANK-YOU Ron.

I forgot the aptvbaen.xls!

I guess this is where I slap myself on the back of the head and chalk it up
to an ID 10 T error! (I get a lot of those!)

> >I have a macro that needs either Workdays or networkdays to determine the
> >number of workdays in a month.
[quoted text clipped - 18 lines]
>
> --ron

Reply to this Message

Ron Rosenfeld - 23 Mar 2006 08:42 GMT

>THANK-YOU Ron.
>
>I forgot the aptvbaen.xls!
>
>I guess this is where I slap myself on the back of the head and chalk it up
>to an ID 10 T error! (I get a lot of those!)

I find I get more of those the older I get :-))

Glad to help
--ron

Reply to this Message