Wincc Oa Excel Run Time Error ! (3.12)

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
11 posts • Page 1 of 2
mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

Hi, I am trying to report excel in wincc oa 3.12. I did the ones written in the help section, but I met the problem shown in the picture. I did research on this topic in the forum, but I could not find the result. I'm waiting for your help.


Image

fheim
Posts:8
Joined: Tue Jun 14, 2011 10:42 am

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by fheim »

Please make sure that you use Office in 32bit
Could you please let us know what OS and Excel version you are using?
Did you install Excel or WinCC OA first?
Do you have sufficient rights to install / register files?

You could try to re-register this file using regsvr32 from /windows/syswow64/

mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

1 - Please make sure that you use Office in 32bit

I am using office 32 bit.

2- Could you please let us know what OS and Excel version you are using?

Windows Server 2008 r2 standart I am using the operating system.

excel

Image

3- Did you install Excel or WinCC OA first?

I first set up the office then scada.

4 - Do you have sufficient rights to install / register files?

Image

Yes, there is the necessary authority.

5- You could try to re-register this file using regsvr32 from /windows/syswow64/


I'm having trouble trying to load from scratch.

Problem picture
Image


Thank you for your interest.

nmnogueira
Posts:125
Joined: Thu May 05, 2011 12:59 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by nmnogueira »

Try to run regsvr32 WCCOAcom.dll from the dll location path (C:\\Siemens\\Automation\\WinCC_OA\\3.12\\bin\\windows\\).

Also, try to debug the VBA and import WCCOAcom.dll from Excel. This has worked for me before.

mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

1- Try to run regsvr32 WCCOAcom.dll from the dll location path (C:\\Siemens\\Automation\\WinCC_OA\\3.12\\bin\\windows\\).

Image

I showed the way with cd. Dll did not work again.


2- Also, try to debug the VBA and import WCCOAcom.dll from Excel. This has worked for me before.

How can i get excel import WCCOAcom.dll

fheim
Posts:8
Joined: Tue Jun 14, 2011 10:42 am

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by fheim »

You need to run the regsvr32 from the path i stated above.
Please try to do it this way:

C:\\Windows\\SysWow64\\regsvr32.exe C:\\Siemens\\Automation\\WinCC_OA\\3.12\\bin\\windows\\wccoacom.dll

mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

He gave the same error. :(

fheim
Posts:8
Joined: Tue Jun 14, 2011 10:42 am

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by fheim »

did you try this in a command box 'as administrator' ?

mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

I've tried. The result is the same

mgulel
Posts:17
Joined: Mon Aug 15, 2016 1:48 pm

Re: Wincc Oa Excel Run Time Error ! (3.12)

Post by mgulel »

The problem continues. What can I do?

11 posts • Page 1 of 2