Compile Time Troubleshooting
If your workbook compilation has failed then please check the following on the computer where the problem appears:
- Please make sure that your workbook VBA code does not contain any syntax errors before compilation.
You need to fix all VBA syntax errors before compiling the workbook with VbaCompiler for Excel. To detect VBA syntax errors, please open your workbook file in Excel and browse to the Excel VBA editor (Alt+F11), and then follow the path: VBA Project main menu >> Debug >> Compile VBA Project.
- Your Windows account may have insufficient security permissions to save files or launch files from certain folders on your computer.
Please copy your models to your “My Documents” folder (or any of its sub-folders) on the local hard drive of your computer and then compile them from there.
Make sure that you have set the ‘Output folder’ path to the “My Documents” folder or any of its sub-folders.
- Antivirus software may hinder the normal behavior of our product. To ensure that our product is working correctly, please temporarily disable your antivirus software and then compile.
- Some third party Excel add-ins may block compilation. We recommend to temporarily uninstall other add-ins, if any are present, to ensure that they do not block compilation.
If you have tried all above and the problem still persists, then please provide the following information to our support email (email@example.com):
- A workbook (xls, xlsm, xlsb) file or add-in (.xla, .xlam) file example with uncompiled VBA code that leads to the compilation problem.
- A screenshot of your compilation options.
- A screenshot of the MS Excel About box from the computer where the problem appears.
In order to find the source of the problem we have to reproduce the same situation on our side, without an example provided by you this is impossible.