CX-Server DDE to Excel

forqnc

Lifetime Supporting Member
Join Date
Jul 2009
Location
Elizabeth City
Posts
148
I didn't want to resurrect an old thread
http://www.plctalk.net/qanda/showthread.php?t=7378&highlight=cx-server+dde

But i'm trying to connect an Omron CJ2M PLC to Excel, my problem is it appears I don't have DDE manager completely installed.
Watching the start of Garry Shortt's video,
https://www.youtube.com/watch?v=ZVLa2Yuxb7Y
he says to right click the icon, then, new project, I don't have that option see attached picture.
I appear to have a CMDDDE under the CX-Server folder which brings up the CX-Server DDE start screen, but no new project.

Any assistance is appreciated

DDE Manager.png DDE ManagerA.png
 
šŸ™ƒ
Thanks for the reply and the Youtube video Garry, will be watching tomorrow.
Why is it the simplest things that frustrate us.
 
I first started out collecting data using the DDE and Excel. Once that was proven, I looked for other ways in which I could collect data from the Omron controller:
VBA - Excel
https://accautomation.ca/how-to-implement-the-omron-host-link-protocol-part-2-vba/
VB6 - visual basic 6
https://accautomation.ca/how-to-implement-the-omron-plc-host-link-protocol/
VB.Net
https://accautomation.ca/implementing-the-omron-host-link-protocol-vb-net/
AdvancedHMI - The easiest method since all of the protocols have been written for the Omron controller and others.
https://accautomation.ca/omron-cp1h-advancedhmi-communication/

Just thought you would be interested in alternative methods.
Regards,
 
Finally got back to playing with this but not having any luck.
I've tried setting up the PLC via USB and Ethernet with no luck.
Only thing I see different to Garry's video is the version of Excel if different, I am using Office 365.
Anyone know if it makes a difference?

=CDMDDE|'U:\CX-Server\Test.cdm'!'\New Point 1' is my command line in Excel
 

Similar Topics

Here is a post that will assist in implementing the Omron CX Server DDE. Utilizing the CX Server DDE Manager will allow us to provide a link to...
Replies
0
Views
2,552
I am upgrading an old RSView32 v7.60 HMI to FactoryTalk View SE version 12.0 and I have an issue. There are some excel reports generated daily...
Replies
2
Views
980
I am building a new galaxy for a customer and I am trying to test things as I go. All my Ethernet PLCs are OK, but I have a test PLC5 in my...
Replies
1
Views
2,123
Is there a utility that people are using for reading MODBUS TCP tags and linking via DDE into an excel spreadsheet live? Any free ones?
Replies
4
Views
2,941
Hi Anyone have the experience using in DDE Server For MODBUSNT, I have one of Standard Automation Control (StA&C) 1995 DDE for MODBUSNT V5.8.2...
Replies
0
Views
1,577
Back
Top Bottom