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

Help Studio
,
1

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

2

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
3

Hi,

Yes, MacroSetting is set at “EnableAll”

4

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

Regards,
Karthik Byggari

5

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.

6

How to check this

7

Hi, has this been solved?

8

Hey, Any updates on this? i am facing same issue

9

Any updates on this issue… I’m facing similar kind of issue in executing the Macro.
I’m using run spreadsheet macro activity and in Excel process with “Enable all” Macro property.

Issue is the macro is working fine for sometime and it’s throwing error on the other time…
If I restart the machine, then the macro executes without any error… This issue is happening frequently.