Attach to running Excel Action(Power Automate Desktop)
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
- Key Entry
- Click on file icon for dialog
- Specify file info variables
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.
Discussion
New Comments
No comments yet. Be the first one!