- ©«¤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-20
|
Public xTime '³]¬°¦@¥ÎÅܼÆ, ©ñ¦b°O¾Ð¤¤¥i¨Ñ¨ä¥¦µ{§Ç¦s¨ú
Sub ¨C¤À°j°é()
xTime = TimeSerial(Hour(Time), Minute(Time) + 1, 0)
Application.OnTime xTime, "¨C¤À°j°é"
With ThisWorkbook.Worksheets("¤u§@ªí1")
.Cells(1, 1) = .Cells(1, 1) + 1
End With
End Sub
Sub °±¤î°õ¦æ()
On Error Resume Next '(²¤¹L¿ù»~) Y¹wq°õ¦æªºµ{¦¡¤w¤£¦s¦b, ¤£µo¥Í¿ù»~
Application.OnTime xTime, "¨C¤À°j°é", Schedule:=False '¨ú®ø¹wq°õ¦æµ{§Ç
On Error GoTo 0
End Sub
¦pªG¹wq°õ¦æªºµ{§Ç¦³«Ü¦hÓ, «h [¹wq®É¶¡] ÅÜ¼Æ ¶·¥Î¨ä¥LÅܼƩΪ«¥ó¦s®Ä, ¦A³v¤@¨ú®ø |
|