Save to two different locations

Hi all,


I want my workbook to save to two different specified locations. After pressing the button it will copy the values of the table to another table.
And after i wanted this to copy the active workbook to another location.

Meaning that it would open the Antonio Tasks.xls and replace the table and save. And after create a coy of Antonio Tasks.xls in another location ( like a backup )

Is this possible ?

PS: I'm using the code below and have tried to implement it but can only save once.

Private Sub CommandButton1_Click()
    Sheets("Home").Select
End Sub

Private Sub CommandButton2_Click()
    Workbooks.Open ("Z:\1. Ennis\7. Antonio Tasks\Antonio Tasks.xls")
    Application.GoTo Reference:="Tabela1143"
    Selection.ClearContents
    Windows("Ennis V1.xlsm").Activate
    Range("Tabela237").Select
    Selection.Copy
    Windows("Antonio Tasks.xls").Activate
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, Transpose:=False
    Application.CutCopyMode = False
    ActiveWorkbook.Save
    ActiveWindow.Close
End Sub

Thanks for all the help !!!