How can I write code that is completely compatible with 2003 and 2007 that utilizes the NETWORKDAYS function. I have this line in 2007 that is giving me trouble in 2003:
I need to rewrite it so that it works on both 2007 and 2003 without the users themselves having to make many changes in add-ons or references or things like that. Any suggestions?
Please Login or Register to view this content.
The NETWORKDAYS Function is only a Worksheet Function since Excel 2007, in prior versions it is part of the Analysis Toolpak. You will need to write your code to check the Version running it and then apply your code based on the result.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
On checking you need to set a Reference to the analysis ToolPak in earlier versions
- Open the VBE (Alt+F11).
- Activate the project where you want to use the function(s).
- Select Tools, References... and check the option atpvbaen.xls.
- click the OK-button to close the References-dialog.
Then you can use the Functions
orPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks