When starting Excel for the first time you receive message "Compile Error: Can't find project or library"
Symptom:
When starting Excel for the first time you receive
message "Compile Error: Can't find project or
library"
Solution:
- Click "ok"
- Click the square stop botton on the toolbar at the top
- Click "Tools" -- > "References"
- De-select the "MISSING: Z Option eZIO Support DLL"
- Click "ok"
- From the menu select "Debug" --> "Compile ZOptionEZIO"
- You will get a compile error - click "ok"
- Click "Tools" --> "References"
- Scroll down to the very bottom and select the check the
box labeled "Z Option eZIO Support DLL" Click "ok"
- From the menu select "Debug" --> "Compile ZOptionEZIO"
- From the menu select "save"
- Click "File" --> "Close"
For NT Operating Systems only:
You may need to re-add the add-in
- Select "Tools" -- > "Add-ins"
- Select "Browse"
- Select your c:\winnt directory
- Double Click "Z Option eZIO.xla" Click "Ok"
- If it asks you to replace say, "yes"
- The "eZIO" menu should now appear in your Excel menu