Macro working fine when running manually but not doing anything within workflow

Hello,

So I’ve created a macro which I’m trying to execute by having an execute macro activity within excel application scope. The process runs just fine, no errors are reported but the macro is not run or at least it does not do what it is supposed to do. The macro is working fine if I start it manually.

Any ideas what is the issue here. I’m using Studio 2019.10.3

Can you verify one more time the following setting in the properties of Excel Application Scope.

Please select EnableAll to enable macros to run.

MacroSetting - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three options, as follows:

  • EnableAll - All macros are enabled and can be run.
  • DisableAll - All macros are disabled in the specified Excel file. No macros can be run.
  • ReadFromExcelSettings - Reads the current Excel Macro settings.

Regards,
Karthik Byggari

1 Like

Hi,

Yes, MacroSetting is set at “EnableAll”

I recommend you to download and see if the following example works or not.

Regards,
Karthik Byggari

Hi,

I downloaded the example and it worked just fine.

The only thing that caught my eye was that the macro of the example excel was not visible when I opened the “macros” from the developer page in excel.