• Replies 3 replies
  • Subscribers 586 subscribers
  • Views 271 views
  • Users 0 members are here
Options
Related

Read Variable using Excel

Subramani Uthandaraman

Hi ,

I'm encountering an issue with Excel with Macro (.xlsm) file which is used to read values from Citect and log it in an excel sheet.

This function is working fine in older version like Citect 7.3 but after upgrade the Citect 7.3 to Plant SCADA 2020R2, the same excel file cannot read values as it can't start the Citect.exe application.

Can anyone advise on this issue?

Parents

  • Sounds like your spreadsheet is using DDE to connect to Citect. In your cells, you should have a formula like: =Citect|Variable!'ProcessVariable1' 

    I believe if the Citect runtime isn't running, Excel would (incorrectly) assume 'Citect' is the application name it needs to run to connect to the DDE server. I believe the DDE topic name 'Citect' was created back when Citect was a 16-bit app and the executable was citect.exe. In Citect 2018R2 and later you have to set the Citect.ini parameter [DDE]Enable=1 because the DDE server is now disabled by default for better security.

Reply

  • Sounds like your spreadsheet is using DDE to connect to Citect. In your cells, you should have a formula like: =Citect|Variable!'ProcessVariable1' 

    I believe if the Citect runtime isn't running, Excel would (incorrectly) assume 'Citect' is the application name it needs to run to connect to the DDE server. I believe the DDE topic name 'Citect' was created back when Citect was a 16-bit app and the executable was citect.exe. In Citect 2018R2 and later you have to set the Citect.ini parameter [DDE]Enable=1 because the DDE server is now disabled by default for better security.

Children
No Data
© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.