Auto Print Report
Hello everyone, I want to auto (daily) print report PDF or Excel file. How can I do that with VBA or another way? Also, I have another question. Can I get logged value (historian) with a specific date and time in VBA macro?? Could you give me some advice,
Popup window
Hi I'm using Zenon 6.22 SP1 and i want to make a popup window when an event occurs. With two YES / NO buttons to activate a boolean variable of a plc. As I can do thanks greetings :) This is a migrated post! Originally posted on 08.08.2014 by user cibertoni.
Does “Interop.zenOn.dll” is compatible with multiple versions of Zenon runtime ( 8 and above ) ?
Does the “Interop.zenOn.dll” is compatible with multiple versions of Zenon runtime ( 8 and above ) ?
API Interfacing in Zenon
Dear All, I am using Zenon 7.00. We are trying to interface the Zenon variable with VBDotNet. How can we get the API (.dll file) file for interfacing with zenon and VBDotNet....? Your quick reply is very helpful for us to work on this task... Best Regards,
How to set Entire Vba Project to variable
Hi Dear support! I am trying write more complicated function but i have a problem with find VBA project, for example (easy example to show problem) what i should set in Set vbProj = ? for example in Excel i will set = ThisWorkbook.VBProject Sub LookingForStringInEntire_VBA_project()
internal function via VBA
i want to execute screen type specific function from Standard Recipe screen "Write Recipe" through VBA
Customizing Internal Functions by using VBA
Hi Guys, There are some dedicated functions for particular screens like 'Alarms', 'ETM', 'CEL' (etc) and they are known as internal functions. My wish is to customize their functionality to meet my requirements. For example, if in a CEL Screen, I wish
Access to the control element via VBA
I have an image with a control element of the type Compatible Elements (Lock). Depending on the logged in user, the name and lockCode should be entered in the control element. My code below: Sub GetUser() Dim zUser As user Dim activeUser As variable Dim
Username
Hello, Thank you for your support in the past. I have a question about the selected username for editing from SE user list. Can I read the value of the username via a variable. best regards
Accessing String Variable Value At VBA
hi, I am tryig to read and write an internal string variable using VBA on zenon V11. While I've managed to successfully write to the variable, I'm encountering a bit of a challenge when attempting to read its value. I'm receiving a Run Time Error whenever
mouse hover effect
i want to use mouse hover to change color of buttons and it worked well with this code. public Sub MouseOver_Default(obElem As Element, vPosX As Variant, vPosY As Variant) thisProject.Variables.Item("scractive7").Value = True End Sub but problem is when
What is the difference between IDynPicture and DynPicture? 8.0RT Normal,8.2RT ERROR
Public Screen As zenOn.IDynPicture Private Sub zScreen_W(ByVal obDynPicture As IDynPicture) Set Screen = obDynPicture 'ERROR End Sub ' Why does 8.0RT not report an error and 8.2RT report an error? 'The same like IVariable and Variable.
Access BIT tag integer
Ei pessoal Sou novo no Zenon, e gostaria de saber, como faço para ler ou escrever o bit em um tag do tipo inteiro Estou usando a instrução em VBA mas está dando erro --- ThisProject.Variables.Item("LGE.UGE.VARIAVEIS_GLOBAIS.TESTE_BIT.00").Value = TRUE
Symbol properties changed via VBA
Hallo! I made a screen, where I used about 200 times a few symbol types. Now, I need to change a Linking Rule property by all of them. It's a lot of work which I will to automatize. All the symbols have standarized Element ID and Visual Name and I'm wondering
RtFunctions - Dynamic Property
Hi! How can i use this dynamic properties in vba? (see attached photo) i have tried but without success. Mainly interesting me this one - "CFktOnlineDruckUmschalten". This Dynamic function let me change set printer in runtime using vba without using popup
Vba editor is not opening?
Dear Zenon team, VBA editor is not opening when press on right click on programming interfaces in zenon editor(V7.60). Please help me. Thank You This is a migrated post! Originally posted on 27.10.2021 by user salman_123. Please be aware that information
Bilder direkt aus dem Explorer laden und anzeigen
Hallo, Ich würde gerne mit einem SPS Signal auf einem Bild direkt eine Grafik anzeigen lassen. Mit welchen Zenon Mitteln wäre das am besten um zu setzen? Hat jemand von Euch so etwas schon mal gemacht? Vielleicht habt Ihr ja für mich ein paar Tipps. Vielen
VBA Complie error Invalid data format
Hello, I have this error when i lauch client zenon I haven't got the probleme the server, with the develloper and runtime application. the module structure is empty on the client The files vba are update when i launch the runtime This is a migrated post!
I need to push data from Zenon VBA to SQL database every 1sec
I need to push the data of a variabe to sql data base through zenon VBA every 1sec once the runtime starts, I am not done much programming in VBA Can anyone share the programming code for this This is a migrated post! Originally posted on 09.06.2021 by
Vba macro should run every 1sec without any external trigger from runtime
Hi, I am using ZENON 8.20 Version, I need to take The Total no. of alarm values into historian, but it is an Screen specific type function, I am not able to take the value so i am using the VBA macro to take the value into variable, But everytime i need
Zugriffsrechte VBA
Hallo Kollegen, Ich habe im thisProjekt 2 VBA Makros die über SPS angetriggert werden. Mit dem einen Makro sollen Dateien kopiert werden. Alle Variablen sind zur Laufzeit vorhanden. Wenn ich das Makro im Debugmodus mit F8 durchspiele funktioniert das
Fehler in VBA in CEL schreiben
Hallo, Ich bin durch diesen Beitrag darauf gestoßen das, wenn ein Fehler in VBA passiert, das man das in die CEL schreiben kann. https://forum.copadata.com/showthread.php?1608-Individueller-Archiv-Export&highlight=WriteCelString Ich habe mir ein Bild
Wenn Fehler mit Dateioperationen eine Wiederholung
Hallo, [/FONT] Funktioniert alles beim 1. Mal dann Exit Sub. [/FONT]Public Sub Ordner_erstellen() Dim oFSO As Object Dim ... usw. On Error GoTo Fehler 'Exportpfad strPfad = "D:\Export" ' Pfad einstellen strOrdner = variabel For i = 1 To 2 Set oFSO = CreateObject("Scripting.FileSystemObject")
Zenon runtime 8 does not execute VBA macro
Dear all, I am unsuccessfull at running VBA macros from the operator's runtime. VBA editor seems to work ok since I can create a form and play with it (buttons, ...). However, when referencing thisProject.Variables it gives back an Empty object. I have
Regular issue with VBA progress bar and RTFunction end sync
I have a problem with this type of code ' Close a image with progress bar ' I don't understand why exports don't keep up with my variable growth export status percentage How can I write code to increase the percentage variable at the end of each finished
Supervisor v7.50 - VBA Wizard
Dear all, I am using zenon Supervisor v7.50 SP0. [SIZE=1] 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 03.06.2020 by user Gosma.
Mit VBA Dateien von einem PC auf einen anderen PC kopieren
Hallo, Ich habe mir eine Batch Datei erstellt (mit Parameter œbergabe) mit der ich von mehreren PCs zu einem anderen PC Dateien kopieren kann. Der Parameter ist für die Datei die kopiert werden soll. Immer eine andere Datei. Jetzt wollte ich diese Batch
Laufzeitfehler 91 ohne weitere Info
Hallo, Ich erhalte im meinem Code den Laufzeitfehler 91: Objektvariable oder With-Blockvariable nicht festgelegt. [/FONT]Public Sub Ordner_erstellen() 'Diese Modul erstellt Ordner Dim fso As Object Dim VarNr As String Dim Vartext As String Dim Verzeichnis
Automate the Excel monthly report by extracting data from the various data source
[color=#333333]usps tracking[/color] [color=#333333]showbox[/color] [color=#333333]speed test[/color] This is a migrated post! Originally posted on 25.03.2020 by user baiselmareo6. Please be aware that information can be outdated.
importing a CSV file.
Hi, I'm Lee. Wanna Do List. 1. Make a new CSV file(excel file). 2. Fill new CSV file's column from a another CSV file. 3. Save the new CSV file. 4. Import the new CSV file to Zenon(variable side). Wanna take a Answer List. 1. Is it possible in Zenon using
Time Sync using MODBUS Variable
Hi guys. We don't have NTP. We need to sync time with DCS based on a trigger from dcs on 5 AM everyday. So DCS connected on MODBUS TCP will trigger bit called Time_sync everyday at 5 AM and when yhis trigger is received we need to set time in our runtime
determining the name of the variable to trigger the function
Hello together, I would like to know how I can access the name of a variable that caused a function to be started. I have got several boolean variables (import-variables from some sensors) that can either be true of false. I also created internal variables
Symbole per VBA verändern/erstellen
Hallo zusammen, ich möchte per VBA ein Symbol verändern, z.B. eine Button einfügen oder eine Eigenschaft nach außen sichtbar machen. Ist das irgendwie möglich? 2te Frage: kann ich ein Symbol per VBA erstellen? P.S. Ich verwende Zenon 8.1 This is a migrated
How to use vb to push Alarm
1. How to use VB to push Alarm? 2. How to push Alarm Text use Zenon Language's TXT? Thanks! This is a migrated post! Originally posted on 15.01.2020 by user utoole. Please be aware that information can be outdated.
Two versions of program in parallel
Can I use two versions of the program in parallel? I have several old projects, I'm worried about their compatibility with the new version of the system that I am going to purchase. Anyone saying that they will never need to take out a loan, I suggest
Event "Object deleted"???
Hallo, Beim z.B. Löschen eines Bildes soll die entsprechende Bildumschaltfunktion gleich mitgelöscht werden. „hnliche Funktionen sollen auch bei anderen Objekten ausgeführt werden. Gibt es ein Event das ausgeführt wird sobald ein Objekt( Bild/Variable/Skript/etc...)
thisProject
Hi all, IÂ've got just a short question: What is the role of Â'thisProjectÂ'in Zenon VBA editor? What is the main difference between moduls and Zenrt32 Objects? I didnÂ't find anything about it. Thank you! This is a migrated post! Originally posted on
VBA was not able to open
Hi, In all my Zenon Version i am not able to open VBA editor. I checked in Zenon6.ini file and VBA related parameter entries are as shown in below. [VBA] EIN=1 EVENT=1 UPDATE=0 Can you please tell me what is the issue? Is there any setting to open VBA
Kann VBA Koordinaten über das Touchpanel erfassen
Hallo an alle, Ich habe letztens in einem VBA Code gesehen das man über Koordinaten Bilder verschieben kann. Meine Frage ist es für Zenon auch möglich mit VBA eine Comobox oder Listbox mir an der Stelle anzuzeigen, wo ich am Touchpanel hintippe??? Damit
Problem with VBA progress bar and RTFunction end sync
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
Next Page