Ãö©óOnTimeµo¥Íªº¿ù»~¡A¨D¸Ñ¡I~~·P®¦
- ©«¤l
- 10
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-3
- ³Ì«áµn¿ý
- 2015-9-11
|
Ãö©óOnTimeµo¥Íªº¿ù»~¡A¨D¸Ñ¡I~~·P®¦
¤p§Ì¥Î¤FworkbookªºOpen¨Æ¥ó¨Ó±Ò°Ê¤@ӥΤFOnTime¥\¯à¡A¨Ó§Û¿ý½L¤¤ªÑ»ùªº§Y®ÉÅܤơA¦ý¶]¨ì¹w³]µ²§ô®É¶¡¡A¥X¤F¤@Ó¿ù»~°T®§¡A½Ð¦U¦ì«e½úÀ°¦£§i¶D§Ú°ÝÃD¥X¦bþ¸Ì¡H
½s½X¦p¤U
Private Sub Workbook_Open()
Application.OnTime TimeValue("21:34:00"), "»ù®t¬ö¿ý"
End Sub
--------------------------------------------------------------------------
Sub »ù®t¬ö¿ý()
Dim Line As Double
Dim Close_T As String
Line = Sheet1.Range("F1").End(xlDown).Row
Close_T = Format(Time, "h:m")
If Close_T <> "21:35" Then
Sheet1.Cells(Line + 1, 6) = Cells(2, 6)
Sheet1.Cells(Line + 1, 7) = Cells(2, 7)
Application.OnTime Now + TimeValue("00:00:05"), "»ù®t¬ö¿ý"
Else
Application.OnTime Now + TimeValue("00:00:05"), "»ù®t¬ö¿ý", , False
End If
End Sub
¿ù»~°T®§¦p¤U¡G
|
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-3
- ³Ì«áµn¿ý
- 2015-9-11
|
¦^´_ 2# stillfish00
·PÁ±zªº¦^ÂСA¦ý§Ú¤£¬O«Ü¤F¸Ñ±zªº·N«ä¡A¦r±¤W§Úªº±Æµ{°£¤F¤@¶}©lªºWorkbook openIJµoªº¬O¤@Ó©T©w®É¶¡¡A¤§«á´N¬O¨C¹j5¬í±Ò°Ê¤@¦¸¡A¤]´N¬O¤U±³o¤@¦æ
Application.OnTime Now + TimeValue("00:00:05"), "»ù®t¬ö¿ý"
Esle¤§«á¨ú®øªº¤]¬O
Application.OnTime Now + TimeValue("00:00:05"), "»ù®t¬ö¿ý"¡A¡AFalse
¥t½Ð±Ð¤@¤U¡A§Ú¸Õn¤W¶ÇÀɮסA¼u¨t²Î§i¶D§Ú¤£¤ä´©¦¹ÃþÂX®i©úªºÀɮסA½Ð°Ý§Ú¸Ó¦p¦ó³B²z¡C |
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-3
- ³Ì«áµn¿ý
- 2015-9-11
|
¦^´_ 2# stillfish00
©Ò¥H±zªº·N«ä¬O¡A¦]¬°§Úªº»Ý¨D¬O¨ì¤F¬Y¤@®É¶¡´N°±¤î¨C5¬í§ì¤@¦¸¸ê®Æ¡A©Ò¥H¡A§Ú¥u¶·§PÂ_®É¶¡¨ì¤F¨S¡A¦pªGÁÙ¨S¦³¨ì¡A´N¹w¬ù¤U¤@Ó5¬í¡A¤@¥¹®É¶¡¨ì¤F´N¤£¥Î¹w¬ù¡AOnTime´N°±¤F¡C¹ï¶Ü¡H
©Ò¥H§Ú¥u¶·§â
Else
Application.OnTime Now + TimeValue("00:00:05"), "»ù®t¬ö¿ý", , False
¬å±¼´N¥i¹F¦¨§Úªº´Á±æ¤F¡I |
|
|
|
|
|
|