How to control a PLC from an Excel file?
- Connection to the Siemens PLC via Kepware with the OPC protocol
- Connection to Excel via Kepware using DDE protocol
Prerequisite: download the following software
- Kepware (OPC + DDE client): www.kepware.com/en-us/product...
- Spreadsheet: Microsoft Excel + VBA Buttons (DDE server)
- Simulated Siemens PLC: PLCSIM Advanced v3.0 (OPC server) support.industry.siemens.com/...
- TIA Portal v16: support.industry.siemens.com/...
👉 If you wish to receive the file of this simulation, indicate it in the comments, and I will send you the program to reproduce this simulation at home
👉 To train yourself in automation: www.udemy.com/course/programm...
#kepware #vba #macro #excel #dde #siemens #industrialautomation #system # industry4 #opc #protocol #network #opcua #kepserver
5 авг 2024