تفضل جرب
Private Sub CommandButton1_Click() 'كود لانشاء نسخة احتياطية للملف
Dim F As Workbook, J As String, Folder As String, ST As Boolean
Dim B, A, ST_Path, strPath As String
On Error GoTo NotAbleToSave
Set F = ThisWorkbook
A = "Backup" ' اسم مجلد الحفظ
B = F.Name
strPath = "C:\" ' تحديد مسار الحفظ
Application.DisplayAlerts = False
On Error Resume Next
If IsEmpty(A) Then Exit Sub
If IsEmpty(B) Then Exit Sub
MkDir strPath & "\" & A
ST_Path = strPath & "\" & A & "\" & B
Folder = "C:\Backup\" ' تحديد مسار مجلد الحفظ
J = F.Name
ST = False
If F.Path = "" Then
Application.Dialogs(xlDialogSaveAs).Show
Else
If Dir(Folder & J) <> "" Then
Kill Folder & J
End If
'(Save) لحفظ الملف النشط تلقائيا يمكنك تفعيل هدا السطر
With F
'.Save
.SaveCopyAs Folder & J
ST = True
End With
End If
NotAbleToSave:
Set F = Nothing
If Not ST Then
End If
MsgBox " : تم حفظ الملف في مجلد" & vbLf & vbLf & Folder & "" & J & vbLf & "" & vbLf & vbCrLf, vbInformation + vbOKOnly, " ! تعليمات"
Application.DisplayAlerts = True
End Sub
MMM.xlsm