OMRON DDE to EXCEL

guest

Guest
G
DDE to Excel Post #1

I read the DDE to Excel Technical letter posted on this site. When I tried it I was not able to connect the CX server to the PLC(i think thats what the problem is). I downloaded the latest version of the Cx-Server from the Omron site(1.7.2). I opened a Escel sheet. I opened my DDE Manager. I went and added a PLC. But I did not get the Network Label n the left of my screen. It only read Devices and Points. Under the Devices it only read New PLC1(that was what I added in the Add PLC step). I went on and added some points also. Then I did what it said in the technical letter(closed all the screens), I right clicked on the DDE Manager on the taskbar and under Project it still read only New, Open and Edit. there was nothing telling "Copy Points".Also I didn't get the screen for the Points Editor where it said Select All.

Can someone who has used it tell me what the problem is.

Thanks
 
Project it still read only New, Open and Edit.

Choose Edit.

In the points editor, from the menu bar choose 'Edit' then 'Select All'.

Then from the menu bar choose 'Edit' again then 'DDE Link'. (This option copies the link info.)

In Excel, select a cell or cells and choose 'Paste' from the 'Edit' menu.
 

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
Hi There. I have PC to get few tags from PLC into C# windows forms application. What is the best and fastest way? I could not find Omron in...
Replies
3
Views
160
Our plant manger/my boss wants each line to display the takt time above the line. I am trying to research the cheapest way to do this. Our plant...
Replies
3
Views
166
Hello everyone. I am new when it comes to Omron PLCs. Currently I'm uploading program from CJ1M PLC using CS1W-CIF31 cable only. I connected the...
Replies
2
Views
98
Hello ! I am trying to use an omron cj2m-cpu33 with a CP1W-CIF01 plug in serial connector to talk to a zebra ZT610 printer. I am getting the data...
Replies
8
Views
316
Back
Top Bottom