Microsoft Excel DDE example

Use the following syntax to establish a hot link from Excel to RSLinx Classic:
= DDESHARENAME'N7:0'
where:
\DDESHARENAME
 is the DDE share the user configures in Windows. If you create a different DDE share name, replace DDESHARENAME with the name of the DDE share you create.
N7:0
 is the item, or address of the data you want to request.
After copying the DDE link to the clipboard, start or switch to Microsoft Excel. Select the cell or group of cells you would like to display live data in.
  1. From the
    Edit
     menu, select
    Paste Special
    . The Paste Special dialog box opens.
  2. Select the
    Paste Link
     option.
  3. Click
    OK
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal