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

[µo°Ý] DDE¨C¤ÀÄÁ°O¿ýªº¸ê®Æ±Æ§Ç°ÝÃD

[µo°Ý] DDE¨C¤ÀÄÁ°O¿ýªº¸ê®Æ±Æ§Ç°ÝÃD

½Ð°Ý§Ú¨Ï¥Îªþ¥óªºÀɮסADEE¨C¤ÀÄÁ¦Û°Ê°O¿ýªº¸ê®Æ¤è¦¡¬O®É¶¡ÂÂ->·s¡A¥Ñ¤W©¹¤U°O¿ý¡C§Ú·Q­n¤Ï¹L¨Ó¬ö¿ý¡A´N¬O³Ì·s¤@µ§ªº¸ê®Æ°O¿ý¡A«O«ù¦b²Ä¤@µ§¡A¨C¤ÀÄÁ¬ö¿ý·|©¹¤U²¾¤@¦C¡A®É¶¡·s->¡C
¨Ò¦p¡G
15¡G53.....
15¡G52.....
15¡G51.....
15¡G50.....
15¡G49.....
15¡G48.....
15¡G47.....
¥H¦¹Ãþ±À.....
½Ð°Ý³o¼Ëµ{¦¡½X­n¦p¦ó­×§ï¡A·P®¦¤j¤j­Ì~
DDE.png
2018-3-8 15:57

20120531a02(DDE¨C1¤À°O¿ý).rar (27 KB)

¦^´_ 1# pcboy60
  1.     Sht1.Range("A" & xRow & ":N" & xRow).Value = Sht1.Range("A8:N8").Value
½Æ»s¥N½X
­×§ï¬°
  1.     Sht1.Range("A9:N9").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
  2.     Sht1.Range("A9:N9").Value = Sht1.Range("A8:N8").Value
½Æ»s¥N½X
¸Õ¸Õ¬Ý¡C

TOP

¦^´_ 2# c_c_lai

c_c_lai¤j¤j¡A«D±`·PÁ±z¡A§Ú¦A¸Õ¸Õ¬Ý~

TOP

½Ð±Ð¤@¤U!  
§Ú¶]¤F¤@¤U³o¤äVBA¡A ¥¦¥u­n¨C°O¿ý¤@¦¸¸ê®Æ ´N·|µo¥X´£¥ÜÁn­µ¤@¦¸ ¦P®É­¶­±¤]·|©¹¤U¶]¡A
­n¦p¦óÅý­¶­±¤£©¹¤U¶] ©MÃö³¬´£¥ÜªºÁn­µ?

TOP

¬O§Ú°O¿ýªº¸ê®Æ¤ñ¸û¦h  ­×§ï¤@¤U±±¨î­¶­± ªº¦æ¼Æ¡A ­¶­±´N¤£·|©¹¤U¸õ¤F!
  ActiveWindow.ScrollRow = xRow - 18 'Åý³Ì·s¸ê®Æ«O«ù¦b¥i¨£µøµ¡¤¤

­×§ï -18 ªº­È´N¥i¥H¤F!

TOP

§ä¨ìÁn­µªº«ü¥O¤F!  ¦bBeep «e­±¥[ '       ´NÃö±¼Án­µ¤F!
   ThisWorkbook.Save   '¦sÀÉ
   'Beep

TOP

½Ð±Ð¤@¤U!
§Ú·Q¥Îpcboy¤jªºµ{¦¡ ¼W¥[¥t¤@­Ó®É¬q StartTime 14:59:50  /  EndTime ¹j¤é 05:00:10¡A ¤]´N¬O¥[¤J¤È«á½L¡C µ{¦¡½X­n¦p¦ó§ï?

<pcboy¤j ªºµ{¦¡½X ¦p¤U>

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 = "21: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

TOP

¦^´_  pcboy60 ­×§ï¬°¸Õ¸Õ¬Ý¡C
c_c_lai µoªí©ó 2018-3-10 05:09


«_¬N½Ð±Ð...­Y³o­Óµ{¦¡¤¤ªº®É¶¡...

­ì¥»¬O1 ¤À...­n§ï30¬í°O¿ý¤@¦¸?¤£ª¾­n¦p¦ó­×§ï

If Second(Time) = 0 And Minute(Time) Mod 1 = 0 Then

·Ð½Ð«ü¾É,ÁÂÁÂ

TOP

¦^´_ 8# jaway


    If Second(Now) = 0 Or Second(Now) = 30 Then

TOP

¦^´_ 9# f3202


ÁÂÁ«ü¾É...

¥i§_¦A«_¬N½Ð°Ýºô¤W°ª¤â...
Sht1.Range("A" & xRow & ":N" & xRow).Value = Sht1.Range("A8:N8").Value

µ{¦¡¤¤ªºÄæ¦ì¬O¨ìN8,­Y§Ú·Q¦A¦h¥[¤@­ÓÄæ¦ì,¬O±NN§ïO¶Ü,¥i¬O
°õ¦æª¬ºAªº¦r¼Ë³£¤@ª½¦bO8ªº¦ì¸m?

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD