Declare PtrSafe Function SetTimer Declare PtrSafe Function KillTime Public mTimer As Long
'计时函数,每一秒钟运行一次
Sub timer ()
ss = DateDiff (" s ","2020-6-110 dd = ss \86400
hh =( ss Mod 86400)\3600 mm =( ss Mod 3600)\60
SS = SS Mod 60
Slide1.Label1.Caption= dd &
End Sub
'1s调用一次 timer 函数计算间隔时间
Sub start ()
mTimer = SetTimer (0,0,1000,
End Sub
' PPT 开始展示时,调用 start 函数,开始显
Sub OnSlideShowPageChange ()
Call start End Sub
' PPT 终止演示时,结束计时
Sub OnSlideShowTerminate ()
mTimer = KillTimer (0, mTimer ) End Sub
大致是这个
vba运行成功后 一两个小时ppt停止运行
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
5条回答 默认 最新
- 「已注销」 2023-03-09 11:16关注
“Devil组”引证GPT后的撰写:
修改:#If VBA7 Then Declare PtrSafe Function SetTimer Lib "user32" (ByVal HWnd As LongPtr, _ ByVal nIDEvent As LongPtr, ByVal uElapse As Long, _ ByVal lpTimerFunc As LongPtr) As LongPtr Declare PtrSafe Function KillTimer Lib "user32" (ByVal HWnd As LongPtr, _ ByVal nIDEvent As LongPtr) As Long #Else Declare Function SetTimer Lib "user32" (ByVal HWnd As Long, _ ByVal nIDEvent As Long, ByVal uElapse As Long, _ ByVal lpTimerFunc As Long) As Long Declare Function KillTimer Lib "user32" (ByVal HWnd As Long, _ ByVal nIDEvent As Long) As Long #End If Public mTimer As Long ' 计时函数,每一秒钟运行一次 Sub timer() Dim elapsedTime As Long Dim days As Long, hours As Long, minutes As Long, seconds As Long elapsedTime = DateDiff("s", "2020-6-11", Now()) days = elapsedTime \ 86400 hours = (elapsedTime Mod 86400) \ 3600 minutes = (elapsedTime Mod 3600) \ 60 seconds = elapsedTime Mod 60 ActiveWindow.View.Slide.Master.Shapes("TextBox1").TextFrame.TextRange.Text = "Elapsed Time: " & _ days & " days " & Format(hours, "00") & ":" & Format(minutes, "00") & ":" & Format(seconds, "00") End Sub ' 1 s 调用一次 timer 函数计算间隔时间 Sub start() mTimer = SetTimer(0, 0, 1000, AddressOf timer) End Sub ' PPT 开始展示时,调用 start 函数,开始显示时间 Sub OnSlideShowPageChange() Call start End Sub ' PPT 终止演示时,结束计时器 Sub OnSlideShowTerminate() mTimer = KillTimer(0, mTimer) End Sub
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 想问一下树莓派接上显示屏后出现如图所示画面,是什么问题导致的
- ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
- ¥15 cmd cl 0x000007b
- ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
- ¥500 火焰左右视图、视差(基于双目相机)
- ¥100 set_link_state
- ¥15 虚幻5 UE美术毛发渲染
- ¥15 CVRP 图论 物流运输优化
- ¥15 Tableau online 嵌入ppt失败
- ¥100 支付宝网页转账系统不识别账号