- ©«¤l
- 75
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 371
- ÂI¦W
- 1
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-4
- ³Ì«áµn¿ý
- 2024-11-11
|
- Sub Timer()
- Dim HHMM As Integer
- On Error Resume Next
- ' Sheets("µ¦²¤°O¿ý").Select
- Sheets(2).Cells(2, 1) = Time '±N®É¶¡show¦Üµ¦²¤ªºb3Äæ¦ì
- HHMM = Hour(Time) * 100 + Minute(Time)
- If (HHMM < 845 Or HHMM > 1345) Then Exit Sub 'Àç·~®É¶¡¤~°õ¦æ
- If Minute(Time) <> LastMin Then '¶}©l«á°µ
- i = i + 1
- If i = 60 Then
- Sheets(2).Range("a10000").End(xlUp).Offset(1, 0) = Time
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 1) = O
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 2) = H
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 3) = L
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 4) = C
-
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 5) = O1
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 6) = H1
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 7) = L1
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 8) = C1
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 9) = O2
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 10) = H2
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 11) = L2
- Sheets(2).Range("a10000").End(xlUp).Offset(0, 12) = C2
- i = 0
- O = Sheets(2).Cells(2, 2)
- H = Sheets(2).Cells(2, 2)
- L = Sheets(2).Cells(2, 2)
- C = Sheets(2).Cells(2, 2)
-
- O1 = Sheets(2).Cells(2, 3)
- H1 = Sheets(2).Cells(2, 3)
- L1 = Sheets(2).Cells(2, 3)
- C1 = Sheets(2).Cells(2, 3)
-
- O2 = Sheets(2).Cells(2, 4)
- H2 = Sheets(2).Cells(2, 4)
- L2 = Sheets(2).Cells(2, 4)
- C2 = Sheets(2).Cells(2, 4)
- Else
- C = Sheets(2).Cells(2, 2)
- If H = "" Then H = Sheets(2).Cells(2, 2)
- If C >= H Then H = C
- If C < L Then L = C
- If O = 0 Then O = Sheets(2).Cells(2, 2) Else O = O
- If L = 0 Then L = Sheets(2).Cells(2, 2) Else L = L
-
- C1 = Sheets(2).Cells(2, 3)
- If H1 = "" Then H1 = Sheets(2).Cells(2, 3)
- If C1 >= H1 Then H1 = C1
- If C1 < L1 Then L1 = C1
- If O1 = 0 Then O1 = Sheets(2).Cells(2, 3) Else O1 = O1
- If L1 = 0 Then L1 = Sheets(2).Cells(2, 3) Else L1 = L1
-
- C2 = Sheets(2).Cells(2, 4)
- If H2 = "" Then H2 = Sheets(2).Cells(2, 4)
- If C2 >= H2 Then H2 = C2
- If C2 < L2 Then L2 = C2
- If O2 = 0 Then O2 = Sheets(2).Cells(2, 4) Else O1 = O1
- If L2 = 0 Then L2 = Sheets(2).Cells(2, 4) Else L2 = L2
- End If
- LastMin = Minute(Time)
- End If
- Application.OnTime Now + TimeValue("00:00:01"), "Timer" '¨C¬íÅã¥Ü
- End Sub
½Æ»s¥N½X ¦^´_ 14# mead
¸Õ¬Ý¬Ý |
|