- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-4-15
|
¼Ò²Õ°Ï:
public uTime '³»ºÝ«Å§i¦@¥ÎÅܼÆ
Sub ³Ñ¾l¼Æpºâ()
........
Call §ó·s
End Sub
Sub §ó·s()
If Time <= TimeValue("19:00:00") Then
uTime= Now + TimeValue("00:05:00")
Application.OnTime uTime, "³Ñ¾l¼Æpºâ"
End If
End Sub
Sub µ²§ôµøµ¡()
on error resume next
Application.OnTime uTime, "³Ñ¾l¼Æpºâ", Schedule:=False
on error goto 0
Workbooks("¥[¤u³Ñ¾l¼Æ.xlsm").Close SaveChanges:=False
End Sub |
|