Checklist: VBA code compilation error

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.
    4. -> 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).