Get Active Worksheet Action—Setting Properties

The Get Active Worksheet action is used return the name or index of the active worksheet in an Excel workbook that is open in an AutoMate Excel session. The action can populate a variable with either the name or index of the worksheet or it can return both the name and index to two separate variables.

An Excel session must be created in an earlier step using the Open Workbook or Create Workbook actions. Variables must be created in earlier steps using the Create Variable action.

Note: You must have Microsoft Excel licensed and installed on your system to use any of the AutoMate Excel actions.

To set Get Active Worksheet properties

  1. From the Task Builder Available Actions pane, open the Excel folder and double-click the Get Active Worksheet action or drag it into the Steps pane.

  2. 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.

  3. Select the check boxes to indicate whether you want to return the name or index or both. Then select the variables in the applicable box or boxes.

  4. To set the Description tab properties, refer to Description Tab Options.

  5. To set the Error Causes and On Error tab properties, refer to Step Error Handling.

  6. When finished, click OK to save settings and close the properties dialog window.

See Also

About Actions

Adding Task Steps