- ©«¤l
- 36
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 86
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-5-4
- ³Ì«áµn¿ý
- 2020-3-26
|
½Ð±Ð¦U¦ì«e½ú,¥Ø«e¬°¤@¤ÀÄÁ,½Ð°Ý¦p¦ó§ó§ï¬°15¬í
Sub ¦Û°Ê°O¿ý()
If uMode = 0 Then Exit Sub
If Time > TimeValue(EndTime) Then '¦¬½L®É¶¡¥H«á¤£°õ¦æ
Sht1.[O8] = "¤w¹L¦¬½L"
uMode = 0
Exit Sub
End If
Sht1.Range("B1") = Time '·í«e®É¶¡¡]®É¶¡½Xªí¡^
'----------------------------------------------------------
'¨C¢°¤ÀÄÁ°O¿ý¡A¢´¤ÀÄÁ«h§ï¬° Mod 5
If Second(Time) = 0 And Minute(Time) Mod 1 = 0 Then
xRow = Sht1.Range("A65536").End(xlUp).Row + 1
If xRow < 9 Then xRow = 9
Sht1.Range("A" & xRow & ":N" & xRow).Value = Sht1.Range("A1:N1").Value
'------------------------------------------------
If ActiveSheet.Name = Sht1.Name And xRow > 20 Then
ActiveWindow.ScrollRow = xRow - 18 'Åý³Ì·s¸ê®Æ«O«ù¦b¥i¨£µøµ¡¤¤
End If
ThisWorkbook.Save ' ¦sÀÉ
Beep
End If
Application.OnTime Now + TimeValue("00:00:01"), "¦Û°Ê°O¿ý" '¨C¤@¬í»¼°j¤@¦¸
End Sub |
|