VBA save as to overwrite

[Pobek]

Can someone help with this syntax? I am trying to save and overwrite any existing file without prompts:

RMOut.SaveAs Filename:=ScenReport, FileFormat:=xlOpenXMLWorkbook, ConflictResolution:=xlLocalSessionChanges

The prompts to overwrite is still comig up interrupting my runs

 

[Joe4]

Here is one way you can do that:

Application.DisplayAlerts = False
RMOut.SaveAs Filename:=ScenReport, FileFormat:=xlOpenXMLWorkbook, ConflictResolution:=xlLocalSessionChanges
Application.DisplayAlerts = True

 

[Pobek]

Here is one way you can do that:

Application.DisplayAlerts = False
RMOut.SaveAs Filename:=ScenReport, FileFormat:=xlOpenXMLWorkbook, ConflictResolution:=xlLocalSessionChanges
Application.DisplayAlerts = True

My code actually does have the preceding display alerts =False. But still not prompting

 

[Pobek]

My code actually does have the preceding display alerts =False. But still not prompting

Think I've found out why ... Thanks

 

[Joe4]

Think I've found out why ... Thanks

Can you share with us the reason?
I am curious, if you already had that code in there.
And it may help someone else someday too.