- ©«¤l
- 85
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 65
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-15
- ³Ì«áµn¿ý
- 2018-9-18
|
¥»©«³Ì«á¥Ñ daniel5168 ©ó 2015-7-28 08:29 ½s¿è
¦^´_ 2# c_c_lai
ublic uMode&, StartTime, EndTime
Public MyBook As Workbook, Sht1 As Worksheet, Sht2 As Worksheet, xRow&
Sub ¦@¥Î°Ñ·Ó()
Set MyBook = ThisWorkbook
Set Sht1 = MyBook.Sheets("Sheet1")
StartTime = "08:44:50" '¶}½L®É¶¡¡]´£¦¤Q¬í¶}©l¡A¤~¥i°O¿ý¶}½L¶q»ù¡^"08:44:50"
EndTime = "13:45:10" '¦¬½L®É¶¡¡]©µ«á¤Q¬í°±¤î°O¿ý¡^¦¹¬°´ú¸Õ¥Î®É¶¡¡A½Ð¦Û¦æ§ó§ï¥¿¦¡®É¶¡ "13:45:10"
End Sub
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("B8") = 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("A8:N8").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
Sub ¶}©l°õ¦æ()
If uMode = 1 Then Exit Sub
Call ¦@¥Î°Ñ·Ó
uMode = 1
Sht1.[O8] = "°õ¦æ¤¤"
Call ¦Û°Ê°O¿ý
End Sub
Sub °±¤î°õ¦æ()
uMode = 0
Call ¦@¥Î°Ñ·Ó
Sht1.[O8] = "STOP"
End Sub
Sub ²M°£°O¿ý¸ê®Æ()
Beep
If MsgBox("¡°½T©wn²M°£¡eSheet1¡fªº°O¿ý¶Ü¡H¡@", 4 + 32 + 256) = vbNo Then Exit Sub
Call ¦@¥Î°Ñ·Ó
Sht1.Rows("9:65536").ClearContents
If ActiveSheet.Name = Sht1.Name Then ActiveWindow.ScrollRow = 1
Beep
End Sub
³oÓ¬O§Ú§ä¨ìªºVBA ¨C¤@¤ÀÄÁ°O¿ý¤@¦¸
§Ú¸Ó«ç»ò§ï¦¨§Ú·Qnªº§â°Ó«~¦P®É¤À¦¨¼Æ¶¤u§@ªí¦P®É¤À§O¨C¤ÀÄÁ°O¿ý¤@¦¸ |
|