Hi Nishant, There are several ways to get information into the controller. If you are set on using Excel then I would use VBA. This method would be best for handling the barcode input. You would not have to be on a specific cell, before scanning the barcode. Here is a link to a sample of communication using VBA in excel: accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/ Video: ruclips.net/video/A0u_2Q9kXnY/видео.html The most robust solution would be to use AdvancedHMI with a barcode scanner. See the links above. Hope this helps you out. Regards, Garry
Hi O J, I have not tried that, but this method of communication is good for a quick view of the information. A more robust communication link to the data can be done through programs like AdvancedHMI. accautomation.ca/omron-cp1h-advancedhmi-communication/ Data can then be stored in a database. Excel or any other spreadsheet can then read the information. This would provide a better solution in my opinion. Thanks for the comment. Garry
@@ACCautomation thank you for the reply. Finally I managed to make it work with LibreOffice Calc. The formula it's a bit different but after a few tries I got it working.
forums.mrplc.com/index.php?/topic/6913-using-excel-to-get-data-from-omron-cj1m-plc/ It sounds like the .cdm file is missing however it is easy to create a new one using the editor with the CX-Server DDE manager. Regards, Garry
Hi, I would like to access the I/O or the DM area of a simulated CJ2M PLC (running in CX-Simulator). Do you have any idea? Will DDE work in this case? CX-Simulator manual says that it can simulate FINS Ethernet communication as well, but I could not set up. Thanks.
Hi K kokemaki, I have not had any luck using the Omron simulator with external devices. If you use the actual hardware you will find that things will work. I hope this helps you out. Regards, Garry
You can just have the one PLC device. This is an older method of communicating to the Omron. I would also look at Node-RED. accautomation.ca/omron-plc-node-red-serial-communication/ Here is a link for the Node-RED series: accautomation.ca/series/node-red-iot-enabling-software/ Regards, Garry
+Garry Respuesto Normally this is installed with CX-Programmer. Start -> Programs -> Omron -> CX-Server -> DDE manager (The path may be different depend on your installation directory) Perhaps it was left out of the install. Try a reinstall of the software. Regards, Garry
This is great! If any one wonder how to use this in Windows 10, the DDE Manager is in C:\Program Files\Omron\CX-Server\CDMDDE.EXE. Everything else is the same... Any idea how I can change the refresh rate? Currently its refreshing every 50ms it seems.
HI Chamudi, If you right click on the CX-Server DDE Manager in the tool bar, you will see the Update Interval... selection. Thanks for the comments. Regards, Garry
HI Marinator Lambert The following post will show you how to communicate to the Omron PLC using VBA in Excel. accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/ Video: ruclips.net/video/A0u_2Q9kXnY/видео.html Regards, Garry
This will come with the Omron CX programmer disk. If you are programming your Omron controllers with CX programmer then you will already have the CX Server DDE. Here is another way to use Excel VBA to get information from the Omron PLC. accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/ Video: ruclips.net/video/A0u_2Q9kXnY/видео.html Regards, Garry
DDE Manager no longer comes with latest CX-Server versions so this is no longer possible. CX-Server Lite is the product that provides same function and requires software licence purchase.
Thanks. Great short end to the point.
How can I make excel as input ?? I want to scan barecode and write value in plc....thank you...
Hi Nishant,
There are several ways to get information into the controller. If you are set on using Excel then I would use VBA. This method would be best for handling the barcode input. You would not have to be on a specific cell, before scanning the barcode.
Here is a link to a sample of communication using VBA in excel:
accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/
Video:
ruclips.net/video/A0u_2Q9kXnY/видео.html
The most robust solution would be to use AdvancedHMI with a barcode scanner.
See the links above.
Hope this helps you out.
Regards,
Garry
Thank you for the video! Have you ever tried to do the same with another software like OpenOffice or LibreOffice calc?
Hi O J,
I have not tried that, but this method of communication is good for a quick view of the information. A more robust communication link to the data can be done through programs like AdvancedHMI.
accautomation.ca/omron-cp1h-advancedhmi-communication/
Data can then be stored in a database. Excel or any other spreadsheet can then read the information. This would provide a better solution in my opinion.
Thanks for the comment.
Garry
@@ACCautomation thank you for the reply. Finally I managed to make it work with LibreOffice Calc. The formula it's a bit different but after a few tries I got it working.
Hi, I have #Bad Project error on my Excel After copy the link...
What can I do?
forums.mrplc.com/index.php?/topic/6913-using-excel-to-get-data-from-omron-cj1m-plc/
It sounds like the .cdm file is missing however it is easy to create a new one using the editor with the CX-Server DDE manager.
Regards,
Garry
Thanks.
It is not missing for sure...
I am using it to get the link of the point for the excel.
And I can see it visual on my pc
I would create a new excel sheet. Then copy the points.
Let me know how you make out.
Thanks,
Garry
Hi, I would like to access the I/O or the DM area of a simulated CJ2M PLC (running in CX-Simulator). Do you have any idea? Will DDE work in this case? CX-Simulator manual says that it can simulate FINS Ethernet communication as well, but I could not set up. Thanks.
Hi K kokemaki,
I have not had any luck using the Omron simulator with external devices. If you use the actual hardware you will find that things will work.
I hope this helps you out.
Regards,
Garry
Is it necessary to have two PLC devices, Admin?
You can just have the one PLC device.
This is an older method of communicating to the Omron. I would also look at Node-RED.
accautomation.ca/omron-plc-node-red-serial-communication/
Here is a link for the Node-RED series:
accautomation.ca/series/node-red-iot-enabling-software/
Regards,
Garry
in omron 9.4version. theres no CX server dde. how can i use it?
+Garry Respuesto
Normally this is installed with CX-Programmer.
Start -> Programs -> Omron -> CX-Server -> DDE manager (The path may be different depend on your installation directory)
Perhaps it was left out of the install. Try a reinstall of the software.
Regards,
Garry
This is great! If any one wonder how to use this in Windows 10, the DDE Manager is in C:\Program Files\Omron\CX-Server\CDMDDE.EXE. Everything else is the same...
Any idea how I can change the refresh rate? Currently its refreshing every 50ms it seems.
HI Chamudi,
If you right click on the CX-Server DDE Manager in the tool bar, you will see the Update Interval... selection.
Thanks for the comments.
Regards,
Garry
Hi, how to write a PLC area from Excel without opc?? Thanks!
HI Marinator Lambert
The following post will show you how to communicate to the Omron PLC using VBA in Excel.
accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/
Video:
ruclips.net/video/A0u_2Q9kXnY/видео.html
Regards,
Garry
Should we purchase any software or license from Omron.??
This will come with the Omron CX programmer disk. If you are programming your Omron controllers with CX programmer then you will already have the CX Server DDE.
Here is another way to use Excel VBA to get information from the Omron PLC.
accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/
Video:
ruclips.net/video/A0u_2Q9kXnY/видео.html
Regards,
Garry
DDE Manager no longer comes with latest CX-Server versions so this is no longer possible.
CX-Server Lite is the product that provides same function and requires software licence purchase.