ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

EXCEL ©w®É¨Ì¤é´Á¦Û°Ê¥t¦s·sÀÉ

EXCEL ©w®É¨Ì¤é´Á¦Û°Ê¥t¦s·sÀÉ

½Ð±Ð¦U¦ì¡A

¦p¦óÅýEXCEL ©w®É¨Ì¤é´Á¦Û°Ê¥t¦s·sÀÉ

ÁÂÁÂ

wl02353427¤j¤j´¿¸gµoªí¹L¥H¤Uµ{§Ç¡A¦ý¦p¦ó±N¸Óµ{§Ç¥t¦s·sÀɮɡA¥¨¶°¤]¤£·|¦P®ÉÀx¦s

¦b¤u§@ªí1 or ThisWorkbook¤U¡G
Private Sub CommandButton1_Click()
startTimer
End Sub

Private Sub CommandButton2_Click()
stopTimer
End Sub

¦b¼Ò²Õ·í¤¤¡G
Sub startTimer()
Application.OnTime Now + TimeValue("00:00:01"), "Increment_count"
End Sub

Sub Increment_count()
hiji = Now()
Range("A1") = hiji

WaitSec = 30 '©µ¿ð®É¶¡

NameOfThisProcedure = "Àx¦sµ{§Ç"

NextTime = hiji + TimeSerial(0, 0, WaitSec)

Application.OnTime EarliestTime:=NextTime, Procedure:=NameOfThisProcedure, LatestTime:=NextTime

startTimer
End Sub

Sub Àx¦sµ{§Ç()
  ThisWorkbook.SaveAs ThisWorkbook.Path & "\" & Format(Now, "yyyymmdd") & ".xls"
End Sub

TOP

½Ð°Ý¦p¦ó³]©w¥t¦s·sÀɪº®É¶¡¡C
§Ú»Ý­n¨C´X¤Ñ¥t¦s·sÀÉ
§Ú¸Õ¹L¦bWaitSec ½Õ¾ã¦ýÀx¦s®É¶¡¦n¹³³£¤£¬O©T©w
THX

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD