Checklist: VBA code compilation error

Time estimate:   15 minutes

Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative.

1. Error still occurs after reinstalled Microsoft Visual Basic for Applications.
2. Microsoft Office or other application supporting VBA was installed before.
   
1. Older versions of Microsoft Office can create problems regarding compatibility, i.e. Small Business Version for Office 2007 + VBA 6.3.
2. zenon was running during installation.
3. Check if the registration of the zenrt32.tlb/zenone32.tlb (both are identical, does not make a difference) is correct for win32 and for win64 in Windows Registry.

-> HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{6F9DE1F1-A404-11CF-95D0-0020D58000EC}\1.0\0\win32

String value: C:\Program Files (x86)\COPA-DATA\[ZENON_VERSION]\zenone32.tlb
-> HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{6F9DE1F1-A404-11CF-95D0-0020D58000EC}\1.0\0\win64
String value: C:\Program Files\COPA-DATA\[ZENON_VERSION]\zenrt32.tlb
->HKEY_CLASSES_ROOT\TypeLib\{6F9DE1F1-A404-11CF-95D0-0020D58000EC}\1.0\0\win32
String value: C:\Program Files (x86)\COPA-DATA\[ZENON_VERSION]\zenone32.tlb
->HKEY_CLASSES_ROOT\TypeLib\{6F9DE1F1-A404-11CF-95D0-0020D58000EC}\1.0\0\win64
String value: C:\Program Files\COPA-DATA\[ZENON_VERSION]\zenrt32.tlb
4. There are no references required by the code missing. References can be checked in VBA Editor in Tools > References.
5. zenWorkspace.vba is write not protected. Renamed zenWorkspace.vba so that a new empty file was created.
6. There are no errors in the code (checked line by line).
7. Searched in Knowledge Base if a previous issue has been addressed.

If the problem persists after completing this checklist and followed corrective actions, please contact your local COPA-DATA Representative providing a SIC-Reduced Report from the target computer(s) and the result of this checklist – please include any additional information or comments related with the points addressed you find relevant.

System Information Collector is a standalone COPA-DATA application that collects relevant data about the Operating System and zenon Software Platform for troubleshooting purposes. SIC is installed with zenon and can be started from zenon Startup Tool (Tools).

• Related Articles

• Checklist: VBA Editor does not start neither wizards

  Time estimate:    15 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Check if zenWorkspace.vba is ...

• FAQ: Can the VBA IDE be opened if my zenon project includes Cyrillic characters in the VBA code?

  The VBA IDE cannot be opened on a windows system without selecting the Russian language first. You will get no error message, it simply does not open. To open the VBA IDE with a project that includes cyrillic characters, you need to set the language ...

• Checklist: VSTA IDE cannot open in zenon

  Time estimate:  15 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Following entries must be set in ...

• Checklist: Component cannot find the license

  Time estimate: 15 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Checklist usage: #. [Quick hints] ...

• Checklist: Smart Client does not work

  Time estimate: 20 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Checklist usage: #. [Quick hints] ...