How to set timout for Invoke VBA activity?

Help Studio
, ,
1

Hi,
I have a workflow similar to what’s shown in Image 1. Occasionally, after invoking a VBA script and saving the file, a message box pops up (as shown in Image 2). This prevents the VBA activity from completing, causing the process to hang for hours unless I manually click “OK to All”.

To handle this, I tried using a Parallel activity to set a timeout. However, during testing, I noticed that the Check App State branch doesn’t run until the VBA invocation is completed—which only happens if I click “OK to All”.

Is there a way to force the timeout or handle the popup without waiting for the VBA to finish?

A workflow sequence in Microsoft Power Automate with steps to save an Excel file, invoke code, assign values, and check the state of the Microsoft Excel application. (Captioned by AI)
A workflow sequence in Microsoft Power Automate with steps to save an Excel file, invoke code, assign values, and check the state of the Microsoft Excel application. (Captioned by AI)641×301 9.51 KB

Microsoft Excel displays a warning message about an invalid or conflicting name that has been automatically replaced, instructing the user to update VBA references and reopen the workbook. (Captioned by AI)
Microsoft Excel displays a warning message about an invalid or conflicting name that has been automatically replaced, instructing the user to update VBA references and reopen the workbook. (Captioned by AI)868×158 11.5 KB

2

Try including

Application.displayalerts=False

in the begining of VBA and see if the error is coming or not instead of handing it via front end

Also good to include all the below

Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Application.EnableEvents = False
Application.ScreenUpdating = False
3

Hi @Anonymous_iL

You can place the VBA code within Timeout Scope activity .

Please do mark it as a solution if it helps :innocent: