SAP Build Process Automation | Excel SDK Trigger Macro

[JoseMelo]

I'm trying to automate a process that involves triggering a macro on an excel workbook. The problem here is that at the end of the macro a popup window confirming the success of the macro appears. The triggermacro activity doesn't end because of that popup and, at the same time, it wont let me use the activity keystroke to end the macro activity.

Any ideas on how I can solve this without changing the macro itself?

[MartinaKolafova · Accepted solution]

Hello, I would change the macro as follows: If you want to inform the user, you can use the status bar in your VBA code (Application.StatusBar). If you still need the popup, capture the screen with the popup and then press the OK button. You will probably need to place the WAIT activity before closing it.