->set breakpoint for stop workflow and test run marco.
It same with deleted the execute macro activity and run marco after run workflow finished
I would like to test run your marco code by using Invoke VBA activity.
1.Copy your marco code and paste it to Text editor(notepad etc)
2.Save it to .vbs file
3.Put Invoke VBA activity to your workflow (inside Excel application scope)
4.Try to run workflow
For emergency solution, Please try to use click activity to click run macro on your excel file.
Click Develiper tab > Click Macros menu > Click Run button
*Don’t forget to use wildcard in your selector.