Utilizing the CX Server DDE Manager will allow us to provide a link to the information in the Omron PLC. This link can be placed on an Excel spreadsheet. Charts, graphs, etc. can be made from the data. We will create links on an excel spreadsheet from a CQM1H and a CP1L PLC. The information will then be displayed as a bar graph comparing the first ten memory areas.
More information can be obtained at our website.
https://accautomation.ca/implementing-the-omron-cx-server-dde-and-excel/
Dynamic Data Exchange (DDE) is a channel through which correctly prepared programs can actively exchange data and control other applications within Microsoft Windows. The DDE manager will allow us to set up all of the links.
00:00 Implementing the Omron CX Server DDE and Excel
00:15 Starting the CX-Server DDE Manager
00:26 Create a new project in DDE Manager
01:06 Add new device
02:09 Start Office Excel and Set Links
05:05 Running the Excel program
ACC Automation
https://accautomation.ca
