Click Macro Button In Excel

[ptrobot]

You can use Execute Macro with the Parallel activity. Add two sequences in the Parallel activity: one for executing the macro and one for interacting with the Save As dialog box. Since they are running in parallel the first sequence won’t block the other.

See the thread below for more details:

How to use activity execute macro and then the macro shows message box yes or no question

You can use the Parallel activity. Separate the Excel Scope into one workflow and the code to click Yes or No in a second workflow. In your main workflow, use a Parallel activity, with two Invoke workflow activities to run the workflows previously created. Make sure that the property Isolated is checked in both Invoke Workflow activities.