Attach to running Excel Action(Power Automate Desktop)

03/10/2023

Japanese version.

This action is to use a Excel book that is already open in Excel.

Launch Excel Action is a similar action for using an unopened Excel book.

Attach to running Excel is used to manipulate an Excel book that has been left open or
Excel book that has been opened by another mechanism.

How to use.

Drag Attach to running Excel from Excel onto the Workspace.

Set parameter.

This action will cause an error if it targets an Excel book that is in a closed state.

Also, while Launch Excel allowed for options such as read-only,
This action is dependent on the state of the book since it is already open. Therefore, there are no options available.

Parameter

Document name

Specify the file to be opened in one of the following ways

When specifying variables, Display select file dialog Action is used. The main case would be for the tool user to select a file.

Variables produced

ExcelInstance

This variable is used to specify the Excel book opened in the subsequent action.

Basically, you can leave it as is, but if you have multiple books open, change the name to indicate what kind of book it is.

On error

Error handling is performed as needed.

Specified Excel document not found

Error when the specified file does not exist.

Failed to attach to Excel document

This is an error when the specified file is in a format that cannot be opened in Excel, for example.

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.

Links

Excel Actions.