Showing results 1 to 5 of 5

Thread: DDE example

  1. #1
    flajoso Gast

    Default DDE example

    Hi all,

    i would like to know if anyone have used DDE to acquire variable values from Zenon to Microsoft Excel, for example.
    I need some help while defining the DDE Link in a cell..

    Thanks in advance.

    Best regards,
    Filipe

  2. #2

    Default Re: DDE example

    when you have set the option "DDE active", you can read the values in MS Excel, using the following string:

    =ZENVIS|variable!variablename

    where variablename should match the name of the variable in zenOn. Now if the zenOn runtime is running, the value should be displayed in the cell in MS excel.

  3. #3
    flajoso Gast

    Default Re: DDE example

    Thank you once again, works fine!!

    Regards!

  4. #4
    Join Date
    16.11.2011
    Posts
    51

    Default Re: DDE example

    Hi,
    where can I find the "DDE active" option"?

    What must i do, if  excel and zenon aren't on the same computer?

    Thanks

  5. #5

    Default Re: DDE example

    where can I find the "DDE active" option"?
    In 8.20 Variable property:
    Additional settings
    see https://onlinehelp.copadata.com/Content.html?product=supervisor&version=820&lang=e n&id=A53CFFF47533B65DCF87C8B8FB7C1F88CED6A184E846E B1648438D30BA6EBA4B

    What must i do, if  excel and zenon aren't on the same computer?
    What is the use case for this?

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •