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

°õ¦æ®É¶¡°ÝÃD?

°õ¦æ®É¶¡°ÝÃD?

¦U¦ì¤j¤j:
ªþ¥óªºEXCEL§Ú³]©w¦b8:45~13:45¶¡°õ¦æ
¦ý¨C¦¸¦b8:45«e°õ¦æ  ¥Hµ¥«Ý8:45¶}©l°O¿ý  ¦ý¥h³£µLªk±Ò°Êµ{¦¡¬ö¿ý
³£¥²¶·µ¥8:45«á°õ¦æ  µ{¦¡¤~·|±Ò°Ê°O¿ý!¤£ª¾°ÝÃD¥X¦b­þ¨à?
Àµ½Ðª©¤W¤j¤j¨ó§U­×¥¿

ÁÂÁÂ

·P®¦

¶q.rar (12.12 KB)

If (TimeValue(Now) <= TimeValue("08:45:00") Or TimeValue(Now) >= TimeValue("13:45:00")) Then Exit Sub 'Àç·~®É¶¡¤~°õ¦æ
­Y¦b8:45«e©Î13:45¥H«á§YÂ÷¶}µ{¦¡

TOP

If (TimeValue(Now) = TimeValue("13:45:00")) Then Exit Sub 'Àç·~®É¶¡¤~°õ¦æ
­Y¦b8:45«e©Î13:45¥H«á§YÂ÷ ...
ANGELA µoªí©ó 2012-6-7 20:05

Dear³o§Ú¯à²z¸Ñ
¦ý°ÝÃD¬O§Ú¦b8:44°õ¦æµ{¦¡«á  ¹L¤F8:45«o¨S°Ê§@°Ú?
·Q°Ý¬O¬Æ»ò­ì¦]©M¦p¦ó­×¥¿?

ÁÂÁ  ·P®¦

TOP

¦^´_ 3# mead
¦]¬°¦b8:45¥H«e¶}ÀÉ¡AÁöµM¦³°õ¦æ¤@¦¸Timer
¦ý¦]¬°ª½±µ¸õ¥Xµ{§Ç¡A¨Ã¥¼·Ç³Æ¤U¤@¦¸°õ¦æTimer
§PÂ_¦¡§ï¤@¤U
  If TimeValue(Now) <= TimeValue("08:45:00") Then Application.OnTime Now + TimeValue("00:00:01"), "Timer"
  If TimeValue(Now) >= TimeValue("13:45:00") Then Exit Sub 'Àç·~®É¶¡¤~°õ¦æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  mead
¦]¬°¦b8:45¥H«e¶}ÀÉ¡AÁöµM¦³°õ¦æ¤@¦¸Timer
¦ý¦]¬°ª½±µ¸õ¥Xµ{§Ç¡A¨Ã¥¼·Ç³Æ¤U¤@¦¸°õ¦æTimer
§P ...
Hsieh µoªí©ó 2012-6-7 20:28

·PÁÂÁ`ª©¥Dªº«ü¾É
¦ý·Ó¦¹­×§ï  ÁÙ¬O¤£¦æ!
¹L¤F³]©w®É¶¡¨S°Ê§@  °h¥X¦A¶i¤J  §YÅܦ¨ÀH®É¦b°O¿ý¤F!
³Â·Ð¦A«ü¾É

ÁÂÁ  ·P®¦

TOP

¦^´_ 5# mead
  1. Sub Timer()

  2. Dim HHMMSS As Integer

  3. On Error Resume Next

  4. ' Sheets("µ¦²¤°O¿ý").Select

  5. Sheets(2).Cells(2, 1) = Time '±N®É¶¡show¦Üµ¦²¤ªºa2Äæ¦ì

  6.   If (TimeValue(Now) <= TimeValue("08:45:00") Or TimeValue(Now) >= TimeValue("13:45:00")) Then GoTo 10 'Àç·~®É¶¡¤~°õ¦æ

  7. ' If Minute(Time) <> LastMin Then '¶}©l«á°µ

  8.     i = i + 1

  9.     If i = 60 Then


  10. Sheets(2).Range("a10000").End(xlUp).Offset(1, 0) = Time

  11. Sheets(2).Range("a10000").End(xlUp).Offset(0, 1) = O

  12. Sheets(2).Range("a10000").End(xlUp).Offset(0, 2) = H

  13. Sheets(2).Range("a10000").End(xlUp).Offset(0, 3) = L

  14. Sheets(2).Range("a10000").End(xlUp).Offset(0, 4) = C

  15.   

  16. Sheets(2).Range("a10000").End(xlUp).Offset(0, 5) = O1

  17. Sheets(2).Range("a10000").End(xlUp).Offset(0, 6) = H1

  18. Sheets(2).Range("a10000").End(xlUp).Offset(0, 7) = L1

  19. Sheets(2).Range("a10000").End(xlUp).Offset(0, 8) = C1


  20. Sheets(2).Range("a10000").End(xlUp).Offset(0, 9) = O2

  21. Sheets(2).Range("a10000").End(xlUp).Offset(0, 10) = H2

  22. Sheets(2).Range("a10000").End(xlUp).Offset(0, 11) = L2

  23. Sheets(2).Range("a10000").End(xlUp).Offset(0, 12) = C2

  24.      i = 0

  25.       O = Sheets(2).Cells(2, 2)

  26.       H = Sheets(2).Cells(2, 2)

  27.       L = Sheets(2).Cells(2, 2)

  28.       C = Sheets(2).Cells(2, 2)

  29.         

  30.      O1 = Sheets(2).Cells(2, 3)

  31.      H1 = Sheets(2).Cells(2, 3)

  32.      L1 = Sheets(2).Cells(2, 3)

  33.      C1 = Sheets(2).Cells(2, 3)

  34.      

  35.      O2 = Sheets(2).Cells(2, 4)

  36.      H2 = Sheets(2).Cells(2, 4)

  37.      L2 = Sheets(2).Cells(2, 4)

  38.      C2 = Sheets(2).Cells(2, 4)

  39. Else

  40.      C = Sheets(2).Cells(2, 2)

  41.      If H = "" Then H = Sheets(2).Cells(2, 2)

  42.      If C >= H Then H = C

  43.      If C < L Then L = C

  44.      If O = 0 Then O = Sheets(2).Cells(2, 2) Else O = O

  45.      If L = 0 Then L = Sheets(2).Cells(2, 2) Else L = L

  46.    

  47.      C1 = Sheets(2).Cells(2, 3)

  48.      If H1 = "" Then H1 = Sheets(2).Cells(2, 3)

  49.      If C1 >= H1 Then H1 = C1

  50.      If C1 < L1 Then L1 = C1

  51.      If O1 = 0 Then O1 = Sheets(2).Cells(2, 3) Else O1 = O1

  52.      If L1 = 0 Then L1 = Sheets(2).Cells(2, 3) Else L1 = L1

  53.    

  54.      C2 = Sheets(2).Cells(2, 4)

  55.      If H2 = "" Then H2 = Sheets(2).Cells(2, 4)

  56.      If C2 >= H2 Then H2 = C2

  57.      If C2 < L2 Then L2 = C2

  58.      If O2 = 0 Then O2 = Sheets(2).Cells(2, 4) Else O1 = O1

  59.      If L2 = 0 Then L2 = Sheets(2).Cells(2, 4) Else L2 = L2

  60.   End If

  61.         LastMin = Minute(Time)

  62. '  End If
  63. 10
  64. Application.OnTime Now + TimeValue("00:00:01"), "Timer" '¨C¬íÅã¥Ü

  65. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  mead
Hsieh µoªí©ó 2012-6-7 21:51

·PÁÂÁ`ª©¥D³o»ò§Ö¦^ÂÐ
­è­è´ú¸Õªºµ²ªG¤w¥i¦æ
©ú¤Ñ½L¤¤¦A´ú¸Õ¬Ý¬Ý

ÁÂÁÂÁ`ª©¥Dªº¼ö¤ßÀ°¦£

·P®¦¦A·P®¦

TOP

¦^´_ 7# mead
ÃöÁä¦b©ó Application.OnTime (TimeValue("08:45:00")), "Module1.Timer"  ¡G
  1. Private Sub Workbook_Open()
  2.     Sheets("µ¦²¤°O¿ý").[a5:n700] = ""
  3.     ' LastMin = Minute(Time)
  4.     Application.OnTime (TimeValue("08:45:00")), "Module1.Timer"      ' *********
  5. End Sub



  6. Sub Timer()
  7.     Dim HHMMSS As Integer

  8.     On Error Resume Next

  9.     ' Sheets("µ¦²¤°O¿ý").Select
  10.     Sheets(2).Cells(2, 1) = Time '±N®É¶¡show¦Üµ¦²¤ªºa2Äæ¦ì

  11.     If (TimeValue(Now) >= TimeValue("13:45:00")) Then Exit Sub  ' ¶W¹LÀç·~®É¶¡«á§Y¸õÂ÷¤£¤©°õ¦æ
  12.     .
  13.     .
  14.     .
  15.     .
  16. End Sub
½Æ»s¥N½X
¦Ü©ó Timer ­×§ï¤@¤U  If (TimeValue(Now) >= TimeValue("13:45:00")) Then Exit Sub
¨ä¥¦³¡¤À¨Ì§A©Ò»Ý¥h­×¥¿¡C

TOP

¦^´_  mead
ÃöÁä¦b©ó Application.OnTime (TimeValue("08:45:00")), "Module1.Timer"  ¡G¦Ü©ó Timer ­×§ï ...
c_c_lai µoªí©ó 2012-6-8 08:07

·PÁÂc_c_lai ¤j¤jªº¼ö¤ß¦^ÂÐ
¥ý¸Õ¸Õ¬Ý
·P®¦

TOP

½Ð±Ðª©¤j­ô¡A¤¸¤jeasywin¤§DDE¡A­n¦p¦ó±N¤§«eªºEXCEL¦sÀÉ¡A¹j¤Ñ¨Ì¼Ë¶}¦¹ÀɮסA­n¦p¦ó³]©w?
ÁÂÁ¡C
devidlin

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD