- ©«¤l
- 6
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 8
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2014-7-19
- ³Ì«áµn¿ý
- 2017-5-25
|
¦U¦ì¤j¤j:
¤p§Ì±q¥L³B¨ú±o¤@Ó¬ö¿ý¨C¤ÀÄÁ§Y®É´Á³f³ø»ù¸ê®Æªºµ{¦¡×§ï¦p¤U¡A
¦ý¬O´Á³fªº¶}½L®É¶¡08:45:00¸Óµ§¸ê®Æ¤@ª½³£µLªk¦¨¥\°O¿ý¤U¨Ó
¤£ª¾¥i§_½Ð±Ð¦U¦ì«e½úÀ°¦£¨ó§U¤@¤U¬Ý¬O§_¦³»Ýnק諸¦a¤è
ÁÂÁÂ
Sub myPrg()
If Timer >= 31440 And Timer <= 49560 Then '¦¤W8:44°_¦Ü13:46¤î
ActiveSheet.Cells(Int((Timer - 31440) / 60) + 4, 3).Value = Range("C2").Value '¨C60¬í,©¹¤U¤@¦C, ¶ñ³Ì·s¼ÆÈ
ActiveSheet.Cells(Int((Timer - 31440) / 60) + 4, 4).Value = Range("D2").Value '¨C60¬í,©¹¤U¤@¦C, ¶ñ³Ì·s¼ÆÈ
ActiveSheet.Cells(Int((Timer - 31440) / 60) + 4, 5).Value = Range("E2").Value '¨C60¬í,©¹¤U¤@¦C, ¶ñ³Ì·s¼ÆÈ
ActiveSheet.Cells(Int((Timer - 31440) / 60) + 4, 6).Value = Range("F2").Value '¨C60¬í,©¹¤U¤@¦C, ¶ñ³Ì·s¼ÆÈ
ActiveSheet.Cells(Int((Timer - 31440) / 60) + 4, 7).Value = Range("G2").Value '¨C60¬í,©¹¤U¤@¦C, ¶ñ³Ì·s¼ÆÈ
Call Timer2 ' <------- §ï¬°Timer2
End If
End Sub
Sub Timer2()
'¨C60¬í°õ¦æ "myPrg" ³oӰƵ{¦¡
Application.OnTime Now + 60 / 86400#, "myPrg"
End Sub
Sub StartTimer()
'±q±Ò°Êexcel ¶}©lªº¨º¤@¨è°_, ¦b60-(timer mod 60)¬í (¬°¤F¤Á»ô¾ã¬í) «á¶}©l°õ¦æ
Application.OnTime Now + (60 - (Timer Mod 60)) / 86400#, "myPrg"
End Sub |
|