Set active Excel worksheet Action(Power Automate Desktop)

08/21/2023

Japanese version.

This action performs sheet selection.

The following action to specify cells in Excel does not specify a sheet, but targets the active sheet.

BGM. Music by mubert.com

Especially in Excel books with multiple sheets, it is recommended to use Set active Excel Worksheet to
It is recommended to specify the active sheet.

How to use.

Specify the target file in Launch Excel Action or Attach Running Excel Action and drag Set Active Excel Worksheet Action from Excel to the Workspace.

Set parameters.

Parameters

Excel instance

Specify the target Excel file.

Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.

Activate worksheet with

Specify the sheet to be active.

Select either Name or Index as the sheet designation method.

Name

Specify the name of the worksheet to be activated.

Index

Specify the worksheet to be active by its index. The index is a sequential number with the leftmost number as 1.

Variables produced

Not present in this Action.

On error

Error handling is performed as needed.

Can't find worksheet

Error when the specified sheet name does not exist.

Failed to activate worksheet

Errors for other reasons.

For those who want to learn Power Automate Desktop effectively


The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.

Table of Contents.

Update History.

Links

Excel Actions.

Examples of Use

Send newsletter. Email one line at a time from an Excel book.

Transcribing from one Excel book to another.

How to get the last business day of the specified month.

How to get the number of business days for a specify month.

How to get the number of business days within a specified period.

How to convert Excel files to CSV files.

How to get the last row and last column of an Excel book.

Create a table of contents for sheet names in an Excel book.

Move to the specified cell in the Excel book.

Delete rows of Excel with specific conditions.

How to delete multiple rows/columns in Excel.

Excel Filter

How to read an Excel file and process it line by line in a loop.