Automation worksheet

Columns

Automation processes are created in the Automation worksheet. This worksheet is automatically generated when AutomationDock is enabled and each workbook allows up to 1000 process rows using the following columns:

1. Process Name column identifies the name of the process. To create a valid multi-step process, all rows in this column must have the same unique process name. Use the column A filter to select a specific process.
2. Action column identifies the automation action that will be performed for that row. Selecting an action will setup and the parameter columns (E-J) for that row.
3. Step description is an optional column used to provide a simple description of the step. The description is also used when generating a process document.
4. Prosess pause (s) is an optional column identifies the length of time in seconds that the application should pause for prior to executing that step. Valid pause length is 0 to 60 seconds. Application automatically pauses to complete each step and entering a pause value is required only to resolve process-specific requirements (for example waiting for a window to open).
5. Parameter column related to the selected action described in detail in the next section.
6. Parameter column related to the selected action described in detail in the next section.
7. Parameter column related to the selected action described in detail in the next section.
8. Parameter column related to the selected action described in detail in the next section.
9. Parameter column related to the selected action described in detail in the next section.
10. Positive outcome redirection column identifies the redirect-to row for positive step result. Once the current step is completed successfully, process will redirect to the specified row. Excel function action that returns a True value can also be considered a Positive outcome.
11. Negative outcome redirectioncolumn identifies the redirect-to row for negative step result. Once the current step is completed with negative outcome, process will redirect to the specified row. Excel function action that returns a False value can also be considered a Negative outcome.Examples of negative outcome is:
    • Excel function action that returns a False or empty value
    • Window select action that does not identify the specified window
    • Item select action that does not identify the specified item
12. Failed process outcome redirectioncolumn identifies the redirect-to row for failed step result. Once the current step is completed with failed outcome, process will redirect to the specified row. Examples of failed outcome are:
    • Invalid Excel function actionInvalid 
    • Window command action
    • Automating a process in a Window that has been closed or, when no parent Window is selected
13. Status column displays the execution outcome of a step. Overall process pass\fail outcome appears in the tool tips on the main menu.
14. Step column displays the execution serial number and time.

Cell colors

The following cell colors are used in the Automation sheet:

• White – editable cells
• Gray – disabled, label cells and read-only result value cells