Create an OPC client with Microsoft ExcelΒΆ

How do you create an OPC client with Microsoft Excel?

See Application Example, OPC

This application example consists of two parts:

  • AC500_to_OPC_Excel_Client.pro:AC500eCo project with symbol and CoDeSysOPC
  • OPC_Excel_Client.xls: MS Excel sheet with VBA program
../_images/22a5970856865c030a317f34501de0c5

Block Diagram

../_images/aa6f0638568970b90a317f346864fafc

Worksheet Control panel for the communication with the OPC-Server.

../_images/48a2b810568ac6f30a317f341a2a1d0e

Worksheet Overview for visualization.

Note

This works also with OPC Server V3 but because of a missing DLL the OPC Server V2 must be installed also.

It will be fixed in later Releases as V2.3.