Hi,

Thanks Nic for the VBA programm update.
It's work fine for me. I'm able to Read/Write values.
But I still have an error with the SetValue function. The Server send me the message : "soap:Server Internal Server Error". (even if the value is correctly written into my HMI)

my sent XML file is like this :

<soap:Envelope>
     <soap:Body>
          <SetValue>
               <A>Tag_13</A>
               <B>4</B>
          </SetValue>
     </soap:Body>
</soap:Envelope>

My HMI is a TP1200 Comfort (6AV2 124-0MC01-0AX0)

I planned to use the server response to know if the setvalue is OK or not.
so If someone has an idea to resolve this error, it will be very helpfull !

thanks in advance

Nic_

I know this is an old thread, but I've been trying to get the SOAP interface working with Excel 2007 on Windows 7 and the examples don't work. In fact in the current WinCC V11 SP2 manual it states that Windows 7 is not supported.

It appears that Microsoft has dropped support for the SoapClient library in Windows 7. You may still be able to get the SoapClient30 to work on Windows 7 32bit with Office 2007, but it appears that the MSSOAP30.dll file will not load on Windows 7 64bit at all and is not supported by Microsoft going forward. Microsoft wants you to use the Visual Studio Web Services to build Excel workbooks to consume services like SOAP. This isn't really practical unless you have Visual Studio Professional and know how to program.

I've managed to build a "work around" of sorts using the XML library which is still supported by Microsoft. So it still accessesthe SOAP WebService of WinCC Advanced by building the XML SOAP call manually instead of automatically with the nice soap library that MS dropped. It's not perfect, I haven't tested it on Windows 64bit yet, but it should be fine. I'll try it out later this week on 64bit. I've only implemented the GetValue function, but extending this with the SetValue should be fairly simple for someone who has done VBA before. Here is a macro enabled Excel 2007 file with the code built into it. You simply fill in the name of the tag you want to pull from WinCC, enter the ip address or name of the HMI Server at the top and press the update button. The sheet will also automatically update the tag list when you load it. You can type "ignore" into lines that you don't want updated and type "end" into the last field to stop the polling script. I haven't put in any error trapping, so use at your own risk. I'm assuming that the SOAP envelope is the same for all WinCC SmartAccess servers (which is a pretty big assumption, so it may break quickly).

Attachment

C:\WinCC_SOAP_Demo_Excel_2007 rev2.zip(201 Downloads)

------------------------------------------------------------------------------------------
Split from WinCC Felixible Smart Access SOAP example GetValue call error.

Hey Julian,

there is a newe FAQ available. Follow this link:

https://support.industry.siemens.com/cs/ww/en/view/69846238

With best regards

rh1990