| View previous topic :: View next topic |
| Author |
Message |
Lune Junior

Joined: 17 Jun 2019 Posts: 7
|
Posted: 24/06/2019 20:21 Post subject: Help about project DBF add in for excel |
|
|
Hello
I want to know if it is possible to set a value of citect tag from excel using projectDBF for excel?
if yes how to do it? |
|
| Back to top |
|
 |
xpjxh11 Junior

Joined: 23 Jun 2019 Posts: 3
|
Posted: 25/06/2019 08:32 Post subject: |
|
|
https://knowledge.insourcess.com/Citect/Tech_Notes/TN_Citect009_How_to_configure_the_Excel_Add_In_for_CitectSCADA_to_Develop_your_HMI_Application
http://proscada.ru/ctkbase.en/articles/q5554.html
http://www.citect.aveva.com/webhelp/vijeo750/Content/UsingMicrosoftExceltoEditdbfTables.htm |
|
| Back to top |
|
 |
Lune Junior

Joined: 17 Jun 2019 Posts: 7
|
Posted: 25/06/2019 11:01 Post subject: |
|
|
| Thanks xpjxh11 but i already went to all that website. The real problem i cannot set the value of tag variable from the excel. |
|
| Back to top |
|
 |
ehtyyjzav Junior

Joined: 25 Jun 2019 Posts: 1
|
Posted: 25/06/2019 19:23 Post subject: |
|
|
| with what version do you work with? |
|
| Back to top |
|
 |
Lune Junior

Joined: 17 Jun 2019 Posts: 7
|
Posted: 25/06/2019 21:11 Post subject: |
|
|
For excel 2007 citect scada 7.20
I try now to do it using DDERead but it does not work also. Do i need to configure something before the use of DDE?
I just want to read one value in excel and display it the scada. |
|
| Back to top |
|
 |
yaqui Member junior

Joined: 30 Aug 2012 Posts: 54
|
Posted: 25/06/2019 23:20 Post subject: |
|
|
It is very easy if you use VBA from Citect.
You can Read/Write Excel file
Search the help, and you will find some tips. |
|
| Back to top |
|
 |
Lune Junior

Joined: 17 Jun 2019 Posts: 7
|
Posted: 26/06/2019 02:50 Post subject: |
|
|
| thanks guys i did it with the DDE functions |
|
| Back to top |
|
 |
|