|
-
Jul 27th, 2009, 10:29 AM
#1
Thread Starter
Frenzied Member
[RESOLVED] [Excel] WorksheetFunction.NetworkDays in 2003
In 2007 I can use the WorksheetFunction.NetworkDays to find the number of business days between two dates.
However, when the code is run on another PC running 2003 (without the Analysis ToolPak) I get an error.
My users are likely to grumble if I ask them to configure something in Excel before they can run my stuff.
Is there anyway to reference the Analysis Toolpak from VBA if it hasn't been installed?
Alternatively, does anyone have any code that replicates this function so I can bypass the issue?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|