Dear all's
Please Help me coding for VAB Excel Time Updating.
I had project needs to 5 times update by the individual work sheet to Run Macros,
- 13:00
- 15:00
- 16:30
- 18:00
- 19:00
what code is situtable for use ..
Billion Thanks
VBA CODING
2007-09-24 10:30 pm
回答 (1)
2007-09-24 11:11 pm
✔ 最佳答案
可否把要求說得詳細一點.2007-09-24 17:55:34 補充：
用 OnTime 這個方法就可以了. 例子如下:Sub sched()Application.OnTime TimeValue("13:00:00"), "my_proc"Application.OnTime TimeValue("15:00:00"), "my_proc"End SubSub my_proc()' Cells(1, 1) = Now()End Sub------------------------只要執行 sched() 就ok.
收錄日期: 2021-04-13 19:33:12
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070924000051KK01381