Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use workdays or networkdays in VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use workdays or networkdays in VBA
On Wed, 22 Mar 2006 19:26:31 -0800, ABG wrote:
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 In the VB editor, Tools/References atpvbaen.xls Then in your macro, just use: Var = workdays(dt,num) --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use workdays or networkdays in VBA
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!) "Ron Rosenfeld" wrote: On Wed, 22 Mar 2006 19:26:31 -0800, ABG wrote: 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 In the VB editor, Tools/References atpvbaen.xls Then in your macro, just use: Var = workdays(dt,num) --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use workdays or networkdays in VBA
On Wed, 22 Mar 2006 20:01:32 -0800, ABG wrote:
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Workdays | Excel Worksheet Functions | |||
Workdays | Excel Worksheet Functions | |||
Workdays/Networkdays #Name? Error | Excel Worksheet Functions | |||
Workdays | Excel Discussion (Misc queries) | |||
Workdays | Excel Programming |