The following example shows how to do this in detail:
5- Drag the created points into your default mimic as names and values and run Microsoft Excel.exe as following:
- If you tried to set some values to the Excel sheet 1 in cells R1C1 (Raw1Column1) ,R2C1,R3C1 you may find no response @ mimic side because the CS DriverDDE.exe is running in a different session/username (inside Task manager) from Excel.exe like following:
- Hence, you need to right click this process (DriverDDE.exe) and End process tree to run it again as administrator (same like your user name) …Double check that the process disappeared otherwise End it again.
- Now go to C:\Program Files\Schneider Electric\ClearSCADA and run DriverDDE.exe as administrator and double check inside Task Manager that it has the same user name as Excel.exe.
You can now manipulate value in sheet1 cells and see them in your default mimic.
End of Article.
1- Open Viewx and login then Create a group Named “Group1”.
2- Create New DDE server inside Group1 and Name it “DDE_SRV”.
Note: you may need to add the DDE protocol if you have a typical installation for ClearScada (CS) and hence, you need to add it using CS software media.
3 - Create New DDE Scanner and name it “DDEScanner”
3 - Create New DDE Scanner and name it “DDEScanner”
4- Create new DDE points Di,Ai and String as following: “Di1,Ai1 and St1” respectively.
Configurations
Configurations
- For DDE_SRV, inside DDE tab set service name “Excel” as below image:
- For DDEScanner, inside DDE tab, set server as “Group1.DDE_SRV” and Topic as “sheet1”
- For Di1 point, do like below
- For Ai1, like below:
- For St1, like below:
5- Drag the created points into your default mimic as names and values and run Microsoft Excel.exe as following:
- If you tried to set some values to the Excel sheet 1 in cells R1C1 (Raw1Column1) ,R2C1,R3C1 you may find no response @ mimic side because the CS DriverDDE.exe is running in a different session/username (inside Task manager) from Excel.exe like following:
- Hence, you need to right click this process (DriverDDE.exe) and End process tree to run it again as administrator (same like your user name) …Double check that the process disappeared otherwise End it again.
- Now go to C:\Program Files\Schneider Electric\ClearSCADA and run DriverDDE.exe as administrator and double check inside Task Manager that it has the same user name as Excel.exe.
You can now manipulate value in sheet1 cells and see them in your default mimic.
End of Article.
Released for:Schneider Electric Canada
