DDE data transfer

Using DDE to transfer data from a PLC to a Microsoft Excel spreadsheet need not be hard work if you set up WINtelligent LINX, DDE and Excel correctly. In configuring WINtelligent LINX, first be sure you can see the processor in a WINtelligent LINX Super Who window. Then begin your DDE topic configuration by clicking […]

Using DDE to transfer data from a PLC to a Microsoft Excel spreadsheet need not be hard work if you set up WINtelligent LINX, DDE and Excel correctly.

In configuring WINtelligent LINX, first be sure you can see the processor in a WINtelligent LINX Super Who window. Then begin your DDE topic configuration by clicking the DDE Server menu and selecting the Topic Configuration option.

Select the Add New Topic button and click OK; key in a Topic Name. Click the Update button and a Super Who screen appears. Next select the processor to which you are connecting and the software enters the processor type after you double click the station number in the screen.

Now, ensure the Data Collection mode is Poll; check the driver is set correctly for this processor; and click OK. Then Minimise WINtelligent LINX.

Note, you can set the Excel spreadsheet to monitor the physical connection to the processor and the DDE hotlinks via Status Item cell and DDE Status cells.

Creating the hotlink itself is done from the WINtelligent LINX Edit menu selecting Copy to Clipboard. When the window appears, key the processor address to link Excel into the Data Table Address field. From the Excel Edit menu select Paste Special, and in the dialogue box select Paste Link and OK.

Finally, enter the macro code for the block read you can now assign a button to it. Clicking the button executes the macro; WINtelligent LINX reads the data from the processor and places it in Excel which puts it into the spreadsheet.

Rockwell Automation, Tel: 01908 838800; Fax: 261917.

755 on enquiry card