- ©«¤l
- 44
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 78
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-5-4
- ³Ì«áµn¿ý
- 2014-4-24
|
¦^´_ 15# GBKEE
¤£¦n·N«ä,§Ú´N¬O«ö·Ó¶W¯Åª©¥Dªºµ{¦¡,µ{¦¡¦p¤U:
Sub auto_open()'¶}Àɮɦ۰ʰõ¦æ¦¹¥¨¶°
GetDDE '©I¥sµ{§Ç
End Sub
Sub GetDDE()
Dim T As Date
T = Now '¨ú±o²{¦b®É¶¡
If Not IsError(Sheets(1).[B2]) Then Sheets(2).[A65536].End(xlUp).Offset(1).Resize(, 7) = Sheets(1).[A2:G2].Value '¤u§@ªí1ªº¸ê®ÆDDE³sµ²¦¨¥\¼g¤J¤u§@ªí2
Application.OnTime T + TimeValue("00:00:02"), "GetDDE" '³o¬O¥H2¬í´ú¸Õ¡A¶¡¹j5¤ÀÄÁ§ï¦¨TimeValue("00:05:00"),
End Sub
§Ú·Q
1.¦A¥[¤J¥xªÑ©Î¬üªÑ¶}¦¬½L®É¶¡,¨Ó³]©w±µ¦¬®É¶¡
2.±N±µ¦¬¶i¨Óªº¸ê®Æ®É¶¡×¥¿¬°" ¤ÀÄÁ¾ã¼Æ",¨Ò¦p 10:15:10 ---> 10:15:00
½Ð°Ýn¦p¦óקï?ÁÂÁ±zªº¨ó§U |
|