Anatomy of a project invocation rule
 Input
Check this box if data is to be acquired from a worksheet in the active workbook and passed to the target project upon invocation.
|
|
 Selected input sheet
The worksheet from which input data will be acquired (if the Input check box is checked) prior to invoking the target project.
|
|
 Input data range
Defines the range of cells belonging to the selected input worksheet from which input data will be acquired (if the Input check box is checked) prior to invoking the target project. This can be either a single cell (e.g. "A1"), a pair of cells defining the diagonally opposed corners of a single area (e.g. "A1:B2") or a range name defined in the active Microsoft Excel workbook.
|
|
 Input range order
Defines the order in which worksheet cell data from the input data range is presented to the target project (if the Input check box is checked).
|
|
 Time limit
A value which, when combined with the time unit, determines the amount of time that Absyntax will allow for a project invocation to complete before terminating the invocation. The minimum value is 1, the maximum value is 999.
|
|
 Time unit
A quantity of time which, when combined with the time limit, determines the amount of time that Absyntax will allow for a project invocation to complete before terminating the invocation.
|
|
 Reload
When checked, the target project is reloaded from file prior to the next invocation.
|
|
 Enabled
When checked, an attempt will be made to invoke the target project on the next run (assuming it is in a valid state – see Status). When unchecked, the target project will not be invoked.
|
|
 Status
Indicates the validity of the project invocation rule.
|
Indicates that all information is correct and the target project file exists.
|
|
Indicates one or more of the following:
-
there is no selected input sheet and the Input check box is checked;
-
the input data range is invalid and the Input check box is checked;
-
there is no selected output sheet and the Output check box is checked;
-
the output data range is invalid and the Output check box is checked;
-
the file path of the target Absyntax project is either blank or does not point to an existing file.
|
|
|
 Output
Check this box if any output data emitted by the project is to be written to a worksheet in the active workbook. Uncheck it if no project output data is to be written.
|
|
 Selected output sheet
The worksheet to which data emitted by the invoked project will be written (if the Output check box is checked).
|
|
 Output data range
Defines the range of cells belonging to the selected output worksheet to which data emitted by the invoked project will be written (if the Output check box is checked). This can be either a single cell (e.g. "A1"), a pair of cells defining the diagonally opposed corners of a single area (e.g. "A1:B2") or a range name defined in the active Microsoft Excel workbook.
|
|
 Output range order
Defines the cell order in which data emitted from the invoked project is written to the output data range (if the Output check box is checked).
|
|
 Project file path
The full path of the file containing the Absyntax project to be invoked. Click the ellipsis button to open a file browser dialogue that will help you find Absyntax projects.
|
|
 Last run
Indicates the outcome of the last invocation of the target project.
|
Indicates a successful invocation.
|
|
Denotes a project that was not invoked.
|
|
Indicates that a non-specific problem arose during invocation.
|
|
|