workbooks(1).saveas for the second time

[lezawang]

Hi
When I run the code below for the first time, I get no error message and file name would change to testing123.xlsx but when I run it for the second time, I get error message saying the file already existed. How can I change that or can I? Thank you very much.

Sub savewb()
  Workbooks(2).SaveAs Filename:="testing123.xlsx"
End Sub

 

[Trebor76]

Hi lezawang,

If you want to save over an existing file no questions asked (I think that's what you're asking), try this:

Sub savewb()
    Application.DisplayAlerts = False
        Workbooks(2).SaveAs Filename:="testing123.xlsx"
    Application.DisplayAlerts = True
End Sub

Regards,

Robert