and/or 
or 
Problems with installation generally fall into two categories: difficulties with software authentication and the user's installation of Excel. Each of these problems is easily identified. That being said, while we can help you with the former, we can only coach you with the latter.
Our experience has been that virtually all execution problems arise during installation. Many of these involve anomalies with Excel installations; most of the rest involve problems authenticating the software. The particular error message or messages you receive provide clues to where the source of the problem lies.
Identifying Problems
Authentication problems. If you see a dialog box like this
and/or or
you are experiencing an authentication problem. Software authentication for the Design Wizard makes use of two files, pcgw32.dll and designcheck.dll, both of which are located in your Windows\System32 directory. If these files don't exist or the version numbers are not compatible with each other, you should contact StatWizards at gboomer1@san.rr.com for a new set of files and instructions on what to do next.
Problems with the user's Excel installation. If you encounter one of the following errors,
, 
, 
, 
or 
,
you have a problem with your installation of Excel. While we are not caretakers of Excel, we can suggest things to do that have helped customers in the past. To begin, click here.
Testing Visual Basic for Applications libraries in your installation of Excel.
IT departments are often quick to point fingers at third-party software, especially if a crash or error message occurs. However, StatWizards are written in Visual Basic for Applications, and the root cause of any compile error may well be the inability of Excel to access the libraries necessary for VBA to run. Sometimes those libraries handle string operations. If so, here is a quick test you can use to see whether your installation of Excel properly supports VBA. Note that this test does not involve any StatWizards software at all. It verifies the ability of Excel to handle any non-trivial VBA programs.
From a blank worksheet in Excel, press Alt-F11. This opens a Visual Basic window. Press Ctrl-G to open a sub-window labeled Immediate. In that window, type the following and then press Enter:
print mid("abcd",2,2)
We are asking VBA to deliver a two-character string starting at the second character of "abcd". Again, this has nothing to do with StatWizards. On the next line you should see the following response:
bc
If you don't see this response, your installation of Excel has a problem accessing the necessary libraries to run VBA, and you will get compile errors when trying to run any StatWizards program or any VBA program that uses strings. Regardless of whether you want to use StatWizards, this is a problem that you or your IT department should fix. For help, click here.
This is just one limited test. Passing it is no guarantee that your installation of Excel is free from problems. We will be glad to work with you or your IT department to get any StatWizards program up and running. Feel free to contact us at gboomer1@san.rr.com or +1 (619) 423-3139.