請測試看看,謝謝
Sub Auto_Open()
Application.OnTime Now() + TimeValue("00:05:00"), "SaveFile"
End Sub
Sub SaveFile()
Application.DisplayAlerts = False
ActiveWorkbook.Save
Auto_Open
Application.DisplayAlerts = True
End Sub
請測試看看,謝謝
Sub Auto_Open()
Application.OnTime Now() + TimeValue("00:05:00"), "SaveFile"
End Sub
Sub SaveFile()
Application.DisplayAlerts = False
ActiveWorkbook.Save
Auto_Open
Application.DisplayAlerts = True
End Sub