Copy Sheet causing a save dialog

[pkinn]

I am currently trying to copy a template sheet from one excel file to another. The copy part works but regardless of what I do the save dialog is shown which pauses the automation.

I’m sure I can write a way to pick up that dialog and click save, but based on what I understand I would assume it shouldn’t be prompting this.

[Che]

Hi @pkinn

As far as I’m aware there’s no simple setting to turn this off.

You can either write a workflow to handle it or suppress the alert through a macro. You can do this in excel and start the macro with a UiPath activity.

i.e.

Sub CloseBook()
        Application.DisplayAlerts = False
        ThisWorkbook.Close SaveChanges = True
End Sub

Kind Regards