Variables can be used in many places. Variables always represent a reference to a value. When the trigger is executed, the respective value of the variable is determined and inserted at this point.
A variety of different variables are available:
- PLC variables
- Excel file variables
- Current file name
- Current path
- System variables
- Current Windows user
- Current system time
All entries that allow the use of variables are marked
the right-hand side. If you click on it, the following dialogue opens and you can select a variable.
You can select variables in the following dialog. At the top you can select the source and below you will find all the variables for this source.
Variables can be used in two main forms:
1. As a selection via a button
If you see the following button, you can click on it and the dialogue for selecting variables will open.
2. Built into a text
Variables can also be part of a text (path, e-mail, etc.). In the text boxes, there is also an
icon on the right-hand side to open the dialogue for selecting variables.
In this example, when the trigger is executed, the file path is supplemented with the value of the PLC variable Data.Product. For example, if the PLC variable contains the value “Sheet 200”, this results in the path: “C:\Users\MB\Desktop\Products\Sheet 200”.
Several variables in one text
Several variables can be used in a text. In the following example, the file name is formed from a static path, a PLC variable and the computer’s timestamp as the current date.
Variable as text only
However, texts can also consist of only one variable.
