How do I resolve the error messages that state Could not load some objects because they are not available on this machine or, Compile error in hidden module: opcProxy ?

How do I resolve the error messages that state 'Could not load some objects because they are not available on this machine' or, 'Compile error in hidden module: opcProxy'?

These error messages are a result of a Windows OCX file which Excel Reporter requires in order to function properly.  You can encounter these errors when using Excel Reporter v3.3.0.22 and installing on a machine that has Office 2003 (SP2 or higher), 2007 (SP2 or higher) or 2010*, however the cases for these errors have been rare.  What occurs is that the OCX file is not registered by the installer and therefore the product does not run properly on the system.  Any time that you attempt to run Excel you will be met with errors similar to those above.

*NOTE:  Office 2010 is not officially supported by Excel Reporter v3.3.0.22.  If you wish to trial Excel Reporter with this version of Office, please contact your Account Manager or OPC Support for additional instructions.

To resolve these errors a full uninstall and reinstall of Excel Reporter along with specific instructions to register the Windows OCX file are required.  Please follow these steps below and note that these steps require that you are an Administrator user on the machine.

  1. Ensure no instance of Excel are open on the machine
  2. Uninstall Excel Reporter using the Windows Control Panel and Add/Remove Programs
  3. Reinstall Excel Reporter
    NOTE:  If you are trialing Excel Reporter, you will need to contact OPC Support or your Account Manager with MatrikonOPC for an installer that will permit this reinstall step
  4. Once Excel Reporter is installed, DO NOT LAUNCH EXCEL UNTIL THE NEXT STEPS ARE COMPLETED
  5. Open a command prompt on your system
    If this is a Windows 7 or Windows 2008 machine, you should open the command prompt by right-clicking the Command Prompt executable shortcut and selecting 'Run as Administrator'
  6. Browse to C:\Windows\System32 (for 64bit OS such as Windows 7 or Windows 2008 C:\Windows\SysWOW64)
  7. Reregister the MSCOMCTL.OCX file
    regsvr32 MSCOMCTL.OCX
  8. You should now be able to launch Excel properly

MatrikonOPC

Topic Information
  • Topic #: 4164-2738
  • Date Created: 06/06/2012
  • Last Modified Since: 07/31/2014
  • Viewed: 3961