cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sschoenherr
Regular Visitor

Launch Excel in On block error retry fails

I have a desktop subflow that tries to launch a spreadsheet. Sometimes the actions in the spreadsheet fail so I want to to try the set of actions up to 5 times.

 

The first time through the subflow Launch Excel works just fine, but if something fails, and the On block error starts over, the Launch Excel command fails with error "Failed to open Excel document '' (Workbooks retrieval error)" even though in the previous iteration it opened fine. Any suggestions?

 

sschoenherr_0-1674683836956.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highboy
Super User
Super User

I think the problem is that you are killing your excel instance, and then try to open a file and connect to the excel instance you just killed.

Highboy_0-1674736405399.png

 

View solution in original post

1 REPLY 1
Highboy
Super User
Super User

I think the problem is that you are killing your excel instance, and then try to open a file and connect to the excel instance you just killed.

Highboy_0-1674736405399.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,482)