- ©«¤l
- 16
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 128
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 123
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-11-8
- ³Ì«áµn¿ý
- 2011-8-8
|
Private Sub Workbook_Open()
Sheet2.[B7:J307] = ""
If Time >= TimeValue("08:45:00") And Time <= TimeValue("13:45:00") Then
change
Else
Application.OnTime "08:45:00", "ThisWorkbook.change"
End If
End Sub
Private Sub change()
Dim TimeRange As Range, Rng As Range, R As Range
With Sheet2
Set TimeRange = .[A:A].Find(TimeSerial(Hour(Time), Minute(Time), 0), LookIn:=xlFormulas)
Set Rng = TimeRange.Offset(, 1).Resize(1, 7)
End With
Rng.Value = Sheet1.[N3:T3].Value
If Time > TimeValue("13:45:00") Then Exit Sub
Application.OnTime Now + TimeValue("00:01"), "ThisWorkbook.change"
End Sub
³o¬O§Ú¨Ï¥Îªºµ{¦¡½X
§ÚSheet1 ¬O¦b±µ¦¬dde¥[¹Bºâªº ³£¦³¥¿±`
¥B¸ê®Æ³£¦³¥X¨Ó
¦ÓSheet2´N¬O§â¨C¤ÀÁ骺¸ê®Æ¦s°_¨Ó
¦ýµo²{ ¦³®É¦³1~3¤ÀÁé¨S¦³§ì¨ì¸ê®Æ
´NÅܦ¨ªÅ¥Õ ¤£¾å±o¬O¤°»òì¦]©O |
|