برجاء تفعيل الكود دا على ملف الاكسل المرفق
Sub Auto_Open()
Dim MyTime As Date
MyTime = TimeSerial(10, 0, 0) ' بداية عمل الكود بعد فتح الملف
Application.OnTime MyTime, "ExportSpecificSheet"
End Sub
Sub ExportSpecificSheet()
Dim WB As Workbook, WS As Worksheet, fName As String
Set WS = ThisWorkbook.Sheets("Sheet2") ' حدد اسم الشيت
fName = "D:\" & "نسخة من البيان الوقتى" & "(" & Format(Now, "dd-mm-yyyy hhmmss") & ")" & ".xlsx" ' حدد اسم و مسار وامتداد الملف
Application.ScreenUpdating = False
Application.DisplayAlerts = False
If WB Is Nothing Then
WS.Copy
WS.UsedRange.Value = WS.UsedRange.Value
Set WB = ActiveWorkbook
With WB
.SaveAs Filename:=fName
.Close True
End With
End If
Set WS = Nothing
Set WB = Nothing
Application.ScreenUpdating = True
Application.DisplayAlerts = True
MsgBox "Your's Sheet Exported Now ...", 64
End Sub
بيان وقتى.xlsx