run-time error 1004 help plz

[bluefeather8989]

I have this marco to save a backup copy to another file. The computer asks me if i want to copy over the same file name. if I say "no" or "cancel " the marco trips up (run-time error 1004). how can i prevent this? Is there a way to make marco run the ok button instead of me having to press it every time?

    ChDir "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows"
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows\TV Shows.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

 

[Fluff]

Do you want to overwrite the existing file every time?

 

[bluefeather8989]

Do you want to overwrite the existing file every time?

yes

 

[Fluff]

Untested, but try

    ChDir "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows"
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows\TV Shows.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
   Application.DisplayAlerts = True

 

[bluefeather8989]

Untested, but try

    ChDir "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows"
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\bluef\OneDrive\Desktop\Excel\Tv shows\TV Shows.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
   Application.DisplayAlerts = True

Works great thanks. ?
??

 

[Fluff]

You're welcome & thanks for the feedback.