Public Declare Function GetTickCount Lib "kernel32" () As Long
Function DelayEx(ms As Long) 'ms是延时的时长,单位是毫秒
Dim start As Long
start = GetTickCount
Do While GetTickCount - start < ms
DoEvents
Loop
End Function
Sub Demo()
Const s As Long = 10
MsgBox "延时 " & s & " 秒后保存然后关闭"
DelayEx (s * 1000)
ThisWorkbook.Save
ThisWorkbook.Close
End Sub 延时后保存关闭.rar(7.2 KB, 下载次数: 104)