Hi Aleksandr Nikulin,
That error usually occurs when there is an issue either with the parameters or the Excel instances, or the Handle or the Workbook name, Path, etc either is missing something or is not configured correctly. So take a look at all those thoroughly first.
To identify whether there is an issue specifically with the Run Macro action, temporarily remove the Run macro action and do something else with the Excel sheet like copy paste data from one sheet to another etc. If it works fine then perhaps the Run Macro has an issue. Then check everything related to the macro, its spelling, does it take parameters. etc. Create a simple sub test() in a new module with a MsgBox "testing" and check whether it shows the message box using Run Macro or does it give the same error. Also check that the macros as enabled at the time when the file opens up from the Show Wb action.
Hi, VJR
Thanks for reply.
1) I tried to play around with different excel action (instead of "run macro") and it works well - created additional excel worksheet, which uses the same inputs [handle] and [WB name], so seems it is ok with them.
2) I created one other simple macro and faced the same exception.
3) Code of Run Macro action itself seems ok for me, I also checked that he takes the parameters.
So, issue is still there, sending you some new screenshots:
1) Macro.jpg - just to show the excel file name and macro name.
2) Process.jpg - process flow with Run Macro parameters.
3) Action1.jpg - Action itself with inputs
4) Action2.jpg - Action with code stage
So, the onlything I assume that the Macro name is incorrect, should there be some kind of extension? As I said previously, [handle] and [WB name] seem ok, as they worked with other action I tried and moreover, they are filled by previous actions withing process flow.
Thank you
Aleksandr