Microsoft Excel DDE via VBA examples

One way to accomplish a DDE write in Excel is through the use of Excel macros, which are DDE cold links. All functions used in these macros are Microsoft Excel standards and are explained in detail in the Microsoft Excel 5 Worksheet Function Reference. The following are four examples using RSLinx Classic with Excel macros:

Read a Word

Read a Block of Words

Write a Word

Write a Block of Words

Set the Active DDE Topic Configured in an Alias Topic

Excel

Excel DDE macro: read a word

Excel DDE macro: read a block of words

Excel DDE macro: write a word

Excel DDE macro: write a block of words

Microsoft Excel DDE example

Microsoft Excel Network DDE example

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.