Desktop flow working by itself but when used in cloud flow returns macro error

(0) Share

Report

Posted on by LW2016

Hello!

My desktop flow runs fine on its own, but when I "Run a Flow built with Power Automate Desktop" I get this macro error:

Problem while executing action 'RunMacro'. Failed to run macro (make sure the macro containing file isn't included in the disabled items list). Can anyone help?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

My guess is that the Excel on the computer it is attempting to run on does not have macros enabled from all sources. I would build into the bot to go to File -> Options -> Trust Center -> Trust Center Settings -> "Enable VBA macros" or Send Keys {Alt}(n), and click OK.

At the end of the bot, I would run the same process and set the Excel Macro settings back to "Disable VBA macros with notification" or Send Keys {Alt}(a) on that same settings window.

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report

I have VBA macros enabled in the Trust Center, but thanks for the suggestions about disabling them after. The macro runs in PA Desktop, just not from the cloud flow calling the Desktop flow.

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report

I have VBA macros enabled in the Trust Center, but thanks for the suggestions about disabling them after. The macro runs in PA Desktop, just not from the cloud flow calling the Desktop flow.

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report

Hello again. The desktop flow was working on its own but I never got it working being called from the cloud flow. And now the desktop flow isn't working. When I try to run it, I get the same error as above. But I can run the macro from the developer tab and the Visual Basic window. Any other thoughts?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hi @LW2016

Can you take a look at this link and see if the solutions work for you.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Error-running-an-excel-macro/td-p/860311

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report

Yes, I have used that link previously. I actually figured it out. I had to disable COM add-ins in Excel. I am not sure why because they were enabled when it was working previously, but it worked this time. I can run the desktop flow from the cloud flow now, the only part I can't figure out is why the email I send with refreshed Excel file (that the desktop flow produces) does not contains the refreshed file. I think it may be because OneDrive has not synched before the email gets sent.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Yes, looks like a sync issue to be handled using Wait stages.

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report

I have determined this is the issue, but have tried several different waits and delays without success. This is from another post but did not work. Do you have any advice?

Was this reply helpful? Yes No