Problem with VBA and RTFunction
Hi guys I have a problem with this type of code Public Sub ExportAllArchive() Dim VarPercentage As Variable Set VarPercentage = thisProject.Variables.Item("VarAuxPercentage") ' VarAuxPercentage is linked to a numeric and is rapresented graphically during
Zenon parameter inVBA script
How can I assing values to a parameter from a VBA funtion from a Zenon Element? I want to use a Funtion with 2 parameters when the user click in a Funttion. I This is a migrated post! Originally posted on 05.09.2019 by user q1883. Please be aware that
Variable between Macro and zenon
How can I give a value for a zenon's Variable in a Macro This is a migrated post! Originally posted on 22.08.2019 by user Omarzubair. Please be aware that information can be outdated.
To Write Value in Variable with Status
Hello, Is it possible to write the variable with status in zenon? I have tried using below program. Sub Dummy() thisProject.Variables.Item("T01_1_2_Command").SetValueWithStatusEx 1, 1078067200, 65545, Now, 666 End Sub Using this program I Get the value
Execute VBA function only if an user has administrator privileges
Hi, I'm on Zenon energy 8.00 and I have a button with a linked function on "Mouse event - LeftClickDown". I set up an Authorization Level on my button to execute the VBA Macros, but if I don't have an administrator level, I receive the Zenon message "You
Setting dyn proprties for BackColor & LinkedFont to indexed values
Hi, I'm trying to set the DynProperties for an element but its not liking it as I'm trying to set them to 'linked' values. elbutton.DynProperties("BackColor") = "8000000E" elbutton.DynProperties("LinkedFont") = "Standard font2" Help file & forum searches
Align Static Text on Screen
I create static text dynamically on screen with command: Dim obProject as Project Set obProject = MyWorkspace.ActiveDocument Dim obPicture as DynPicture Set obPicture = obProject.DynPicture.Item(0) Dim newElement as Element Set newElement = obPicture.Elements.Create("new_text",
Openning Logic project in Editor Using Macros
Hi, I just done all VSTA/VBA training and interested in which. but I am not good at programming skills. I often use Zenon Logic project in the practical project. So, I wonder I could open another Zenon project's Zenon Logic project and see My previous
Variable bei Erstellung in Rezept einfügen
Danke P.S.: Ich verwende den Rezeptgruppenmanager This is a migrated post! Originally posted on 10.04.2019 by user wenzm. Please be aware that information can be outdated.
ActiveX component can't create object
Hello So W10 64b / Zenon 7.20 32b I get this error when I run a VBA wizard. Have registered the OCX files and the standard program but no joy Any ideas please? This is a migrated post! Originally posted on 05.04.2019 by user lss. Please be aware that
Running VariableChange Events
[Zenon Editor 6.51] I have a problem when I call a function from a VariableChange Event; The function I'm calling executed a CMD prompt to start a f.t.p. download. This process takes a few seconds to complete. And thus the function has to wait (while
VBA Skript bei mehrfacher Bildaufschaltung
Guten Tag, vielleicht kann mir jemand helfen ? Ich nutze die Option der mehrfachen Bildaufschaltung für mein Projekt. Im Bildaufruf verwende ich die Möglichkeit, durch Substitution verschiedene Variablen mit gleicher Abstammung zu nutzen. In einem VBA
Time Filter with "Print Extended Trend diagram" function
Hello All, I am using Zenon 7.50 SP0 Build 49034. I want to print a trend with a function of type "Print Extended Trend diagram" But the time filter should be set automatically with a VBA-Makro. I want to set the same "absolute Time" filter which is used
Accessing Variable property from VBA function call
[Zenon Editor 6.51] I'd like to achieve the following, but I'm at a loss; When a variable reaches boolean value '1' (via a PLC), I need to execute a VBA macro that will handle a further process. Alas that process needs to know the name of that particular
Problematically creating symbols - unique PropSymbolNumber
Hi, I'm using some code to create linked symbols on a screen & have run afoul of not using unique Symbol numbers (Dynproperty PropSymbolNumber). Is there a method to check for existing values? Only way I can think of is to loop through all the symbols
Change global variable from PopUp window
I need help in typing function. I have some buttons, what call PopUp window. And i need change value of global variable on button press vulue = variable name on this button This is a migrated post! Originally posted on 19.11.2018 by user xxxd0nixxx. Please
non-linear value adjustment macros - how to set values without endless loop?
Hello, after long searching and trying I came to no result. These options are poorly documented and I didn't find any examples. In the help one can find this: AdjustScadaValue Only available, if non-linear value adjustment is active: Macro is executed
Edit formula of MATH Variables
Dear Support Please suggest and provide a sample code on how to edit the formula section of the Math variables. I want to add Variable, select Formula definition and add actual Formula by vba. Best Regards Sarfaraz This is a migrated post! Originally
Funktion ruft Script nicht auf
Hallo, Wir haben VBA Scripte die Werte in eine Text-Datei schreiben. Diese Scripte werden durch eine Funktion aufgerufen. Die Funktion wiederum wird durch den Grenzwert 1 der Variabel aufgerufen. Mit ein paar Anpassungen habe ich das als Vorlage für ein
64-bit VBA code for file browse
In case anyone needs to get a 64-bit file browser working here's how I got it to work (code adapted from code written by someone much smarter than me online). I used this code for browsing files from within the editor... YMMV if using in the runtime (which
function in report generator
Hi, I'm trying to write a function and access it from report generator to convert archive time and some mathematical calculation . for example type in cell : =myfuncion(a1:b1) how i can do it from vba or vsta ? Thanks, Ali This is a migrated post! Originally
MouserOver on button
Hi, I want to add a mouseOver effect on buttons using VBA. So far my code goes as follows : VBA Code: Public Sub MouseOver_Color(obElem As Element, vPosX As Variant, vPosY As Variant) obElem.BackColor = RGB(246, 152, 4) obElem.ForeColor = RGB(255, 255,
How can I manipulate the elements of a GIS control Activex?
Dear How can I manipulate the elements (context menu with linked zenon function) of a GIS control Activex? For example in the attached image in the GIS control Activex I have the context menu named "SET01_O-242_5", I would like through VBA O C# to manipulate
VBA Import Equipement Modeling
I don't find how i can import with VBA equipement modeling XML file This is a migrated post! Originally posted on 17.10.2017 by user johanngrimaud. Please be aware that information can be outdated.
Mit Button und Makro ein bestimmtes Bild öffnen.
Hallo, Ich habe mir 2 Buttons erstellt die übereinander liegen. Die Sichbarkeit der Buttons wird über die SPS gesteuert. Funktioniert ohne Probleme. Der untere Button wenn er von der SPS freigegeben wird soll mir ein bestimmtes Bild aufrufen.(Bild heißt
Visibility from 2 variables
Hello, Is any posibility to make a visibility depends of 2 different variables? Current status I have: -variable "Pos[BVAR]" where BVAR is changed for 10 positions (10 different blocks of HMI) -graphic with visibility from "Pos[BVAR]" (graphic is visible
VBA for command prompt
Hi I need a VBA code to call multi command in telnet in Zenon Ex : Call cmd.exe Call Sendkeys ( Telnet x.x.x.x) Wait time... Call Sendkeys (Enter) .. Call User Call Password But It can not work , It stop in Dos window and not send and keys after click
UserChange() Event
Hello , i have a problem with UserChenge() event , when i change user in the runtime this event is not execute i don't know why . My code is below : Project_Active() = thisProject.Passwords End Sub [/FONT]_UserChange() MsgBox("it's working") End Sub [/FONT][LEFT]
Cdate Format vorgeben
Hallo Zusammen, ich habe eine Sting Variable in der ich über die Funktion "Write Time to variable" ein Datum und eine Uhrzeit abspeicher. Diesen Inhalt möchte ich in einem VBA Skript wieder in ein Datum umwandeln um es für einen Zeitfilter verwenden zu
Logins mit VBA in einer Datei festhalten
Hallo, Ist es mit VBA möglich, wenn sich jemand anmeldet das der Benutzername mit Datum und Uhrzeit in einer Datei gespeichert wird? Ich kenne mich mit VBA nicht aus. Hat jemand von Euch vielleicht schon so ein Script auf Lager? Ich wäre Euch sehr dankbar
SICAM 230 V7.0 Vbs Error
Hi All, I have problem with SICAM 230 V7 runtime, while I running the runtime an error are coming, it said that MSCOMCTL.OCX is missing, then I copied the missing file from another engine and register . But the error still appear. Please suggest the possible
ActiveX problem
Dear all, I am trying to create an ActiveX with Visual Studio 2015. I created everything and when I start the Runtime in my own computer (where I have the Editor), the ActiveX is working properly. But, when I start the ActiveX in my Runtime Server, the
VSTA Editor IN 32 bit Zenon 7.6 Editor
I tried to open VSTA Editor, but the VSTA Editor is not opened in 32bit Zenon 7.6. OS: Windows 10, 64 bit Zenon Editor: 32 bit I tried like this: 1. Open VSTA Editor with ProjectAddIn... 2. I selected C#, and clicked OK. 3. But the editor is not open,
VBA Variable at ZENON 7.6, thisProject.Variables.Item("varName").Value returns Err
I am using ZENON 7.6. 1. Define a value. userID 2. Set value. thisProject.Variables.Item("userID").Value = adoRecordSet("UserID") In ZEON Runtime, I can display this value. 3. Get value. <-- Error But in VBA Editor, below code returns error. ( I programmed
How many does value of variables insert into the oracle DB in 1 sec ??
Hi, All Using a zenon supervisor 7.10 64bit in HP server 2008. and Oracle 11g and now, updating the data(value of variables) into DB via a zenon Gateway. but, as many as increasing, getting down the speed of updating . i think, 600 row may be maximum
how to replace zvariables with user submitted variables via the hmi
OK, once again I am completely new to zenon and I know this is very basic stuff. I am searching everywhere i can think for answers but maybe someone here can help. We have startup variables that need to be replaced with user input variables via the hmi
FileDialog
I am just learning zenon and am having trouble getting a file dialog box to open. I need to have a filedialog box open when a button is clicked so that a file can be selected. I have tried lots of different things but am just not getting it correct. Can
Rename Variables from VBA Wizard
Dear all, I am using zenon Supervisor v7.50 SP0. Is there any way to rename variable from VBA Wizard? ModifyVariable method can not do that! Best reagrds, Svetozar Yolov This is a migrated post! Originally posted on 10.04.2017 by user yolovs. Please be
Execute VBA Macro
Hello It looks that the function execute vba macro does not work when the sub contains a parameter It works only if you have a sub without parameter Sub test() Sub test (mstring As String) does not work I use zenon 7.50 Is this correct? or did I do something
no stop code 'Do while'
Hi All I hope that everything is good for you. Using zenon 7.10. Supervisor. I put the 'Do while' code into zenon. "Public Sub RightClickDown" But It is stopped automatically at 23:59:59. I want that it is working continuously. Never stop working. Let
Next Page