' ' This is required because of the NETWORKDAYS formula ' that is used in the charts. Go to your applications folder in your finder menu and open the XLSTAT application. Once the zip downloads the Data Analysis ToolPak will go through a few steps to import itself into your Microsoft excel application as an add in. ![]() ' If not, then notify the user and end the program. Sub CheckToolPak() ''''''''''''''''''''''''''''''''' ' Checks to see if the Excel version comes before Excel 2007, ' if so then checks to see if the Analysis ToolPak is installed. Create a Routine to Check for the Analysis ToolPak Open the Visual Basic Editor (Alt+F11) then choose Insert > Module and enter the following VBA code. I want to see if they are using a version of Excel older than 2007, check if they have the Analysis ToolPak installed, and then tell them, with a pop-up message, to install the Analysis ToolPak, so all the will work correctly. ![]() The only way for me to avert an error with users who don’t have the Analysis TookPak installed in Excel 2003 is to use some VBA code that runs when the file is opened. The NETWORKDAYS function is a standard function in Excel 2007, but with 2003 you have to install the Analysis ToolPak, otherwise you get an error. I recently began using the NETWORKDAYS function in Excel 2007, yet my file was going to be widely used by people with Excel 2003 (both are Windows versions).
0 Comments
Leave a Reply. |