Excel-Report can\'t be configured

frankySie · Post by **frankySie** » Mon Jan 14, 2013 10:49 am

when following the WinCC OA help information to configure the Excel-report,
this error is displayed by Excel:

Is this problem caused by WinXP OS or Excel or WinCC OA?
Computer runs a WinXP 32 bit and Excel 2007 SP2.

buec · Post by **buec** » Tue Jan 15, 2013 3:50 pm

Try to register MSCOMCTL.OCX in cmd.exe.

C:\\Windows\\System32\\regsvr32 mscomctl.ocx

Best regards
Christoph

leoknipp · Post by **leoknipp** » Tue Jan 15, 2013 4:21 pm

Hello,

if the problem still occurs after registering the mscomctl.ocx-component you could run the attached VB-script.
The script checks if necessary components for the Excel-report are installed.

Please send the result and a detailled problem description to the official WinCC OA support.

Best Regards
Leopold Knipp
Senior Support Specialist https://www.winccoa.com/fileadmin/image ... Env_31.zip

frankySie · Post by **frankySie** » Wed Jan 16, 2013 3:04 pm

please let me report the result directly here. It is unclear what email address to use. Please forward this report to your support. Thx.

check environment for PVSS Report
create object 'Forms.SpinButton.1' ... OK
create object 'Forms.ListBox.1' ... OK
create object 'Excel.Application' ... OK
create object 'MSComCtl2.DTPicker' ... OK
create object 'MSComctlLib.TabStrip' ... OK
create object 'ADODB.Connection' ... OK
create object 'SubTimer.CTimer' ... failed 429: Objekterstellung durch ActiveX-Komponente nicht möglich
create object 'PVSS00Com.ComManager' ... failed 429: Objekterstellung durch ActiveX-Komponente nicht möglich

leoknipp · Post by **leoknipp** » Wed Jan 16, 2013 3:33 pm

Hello,

how to reach the ETM Support is described at the following entry at the ETM Portal
Home --> FAQ --> General --> How can I reach the ETM Support?

Which information is required is described at
Home --> FAQ --> General --> Which information is necessary to open a service request for the WinCC OA support?

Please notice that the ETM Portal does not substitute the common WinCC OA support.

The output for the VB-script describes that 2 necessary components are not installed or registered.

Best Regards
Leopold Knipp
Senior Support Specialist

tmalone · Post by **tmalone** » Mon Jan 28, 2013 11:47 pm

There are new patches and batch files available for this solution. Please contact support for this solution.

Issue also exists for MaPara tools

WinCC OA x64 on x64 OS with Excel 32-bit.

Todd Malone
HMI CoC

Bugs / Problems