The Activate Cell action is used to activate one or more cells in an Excel workbook that is open in an AutoMate Excel session. An Excel session must be created in an earlier step using the Open Workbook or Create Workbook actions.
Note: You must have Microsoft Excel licensed and installed on your system to use any of the AutoMate Excel actions.
From the Task Builder Available Actions pane, open the Excel folder and double-click the Activate Cell action or drag it into the Steps pane.
In the Session name box, enter the session name. If your task has only one Excel session and you did not change the default session name when you created it (recommended), you can use the default entry.
In the Populate variable box, select the variable to populate.
In the Activate box, select the cell specification method. Then enter the applicable properties in the boxes below:
Cell by reference: Enter the reference for the cell such as A1 or B5.
Cell by position: Enter the row number and the column number in the applicable boxes.
Range of cells by reference: Enter the cell references for the upper left cell and the lower right cell.
Range of cells by position: Enter the row and column numbers for the upper left cell and the lower right cell.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
Adding Task Steps