How To Access Project Variables
Hello, I'm new in Copadata SCADA and I'm trying to edit Zenon7.0 Supervisor project and I'm trying to use VBA macro in a Function (in that way I'm working with successfull with other SCADA systems). Where is my mistake in this vba macro:
Public Sub OPEN_FILE_EXCEL()
Dim objExcelApp
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Visible = 1
objExcelApp.Workbooks.Open "D:\PROBA\PROBA.xlsx"
objExcelApp.Cells(1, 2).Value = "proba zenon"
objExcelApp.ActiveWorkbook.Save
objExcelApp.Workbooks.Close
objExcelApp.Quit
End Sub
This script is working fine without the row "....Cels(1,3) = ...." I may have a mistake in a way to access variable value from variables of the project. How to access that variables?
or in this script:
Public Sub TRANSFER_DAILY_FACTORY_VALUES()
thisProject.Variables.Item("VARIABLE_NAME_Driver_for_INTERNAL_1").Value = thisProject.Variables.Item("PLC1..GLOBAL_VARIABLES.VARIABLE_NAME_2_from_CoDeSys_OPC_DA_driver").Value
End Sub
Thank You in Аdvance
This is a migrated post! Originally posted on 25.01.2016 by user georgi. Please be aware that information can be outdated.