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

µ{¦¡½X¦p¦ó¼g(¥H³s±µEXCELªºDDE¼Æ¾Ú¨C¤ÀÄÁ¬ö¿ý)

µ{¦¡½X¦p¦ó¼g(¥H³s±µEXCELªºDDE¼Æ¾Ú¨C¤ÀÄÁ¬ö¿ý)

§Ú°Ñ¦Ò¹Ljimmy121212¤j¤jªº''¦p¦ó±N¥H³s±µEXCELªºDDE¼Æ¾Ú¨C¤ÀÄÁ¬ö¿ý©O''¤å³¹
¦ý¬O§Ú¬O·sµù¥Uªº
©Ò¥H¨S¿ìªk¤U¸üªþ¥ó
¤]¨S¿ìªkª½±µµoµu®ø®§°Ý jimmy121212¤j¤j©ÎGBKEE¤j¤j
¥u¯à¬Ý¨ì¤ù¬qªºµ{¦¡½X
©Ò¥H¤@ª½·d¤£©w
¥i¥H¦³­þ¦ì¦n¤ßªº¤j¤j
ª½±µ§âµ{¦¡½X¶K¦b¦^ÂФ峹¤Wµ¹§Ú¶Ü(¤£­n¥Îªþ¥óªº¦]¬°§Ú¨S¿ìªk¤U¸ü)
¸U¤À·P¿E!!!

¦^´_ 1# durian77
¤W¶Ç§AªºÀÉ®×,»¡»¡§Aªº°ÝÃD!

TOP

GBKEE¤j§A¦n:

¥ý·PÁ§Aªº¦^ÂÐ!§Ú­ì¥»¬O·Q¥Îexcel°O¿ý¤U¨C¤ÀÄÁ¥x«ü´Á©M¥xªÑ«ü¼Æªº»ù®t¡A¦A¹º¦¨¬Wª¬¹Ï¡C
¦b°Ñ¦Ò§A¤§«e¦^ÂЧO¤Hªº¤å³¹«á¡AÃö©ó¨C¤ÀÄÁ§ì¸ê®Æ³o³¡¤À¤w¸g¨S°ÝÃD¤F¡A¦ý¬O¥Ø«eªº°ÝÃD¦b¸ê®ÆÂন¬Wª¬¹Ï®É¡A·|¥X²{''°õ¦æ¶¥¬q¿ù»~'424'¡A¦¹³B»Ý­nª«¥ó''¡A«ö°»¿ù«á¡A¤Ï¶À¥X²{¤U¦CSet TimeRange = [A:A].Find(TimeSerial(Hour(Time), Minute(Time), "00"))¡A±µ¤U¨Óexcel´N¨S¿ìªk¥¿±`ªº§ì¸ê®Æ¤F¡A¦ý¬O§Ú§â¹Ï§R±¼¡A¦A­«·s¶]µ{¦¡¤S¥i¥H¡A¹ê¦b¬O«Ü¯Ç´e¡C
¦]¬°¥xªÑ¦¬½L¤F¡A©Ò¥H§Ú¥Î¼w°êÁÙ¦³­^°êªº«ü¼Æ§@½m²ß¡A¬Wª¬¹Ï¦bsheet2¡A¥Î´I¨¹e01¶Ç°e¸ê®Æ
·PÁ¦^ÂСA¤£³Ó·P¿E!!!

Book1.rar (10.21 KB)

TOP

¦^´_ 3# durian77
§A¥Ø«eªº°ÝÃD¦b¸ê®ÆÂন¬Wª¬¹Ï·|¥X¿ù ¥i¬OªþÀɤ¤¨S¬Ý¨ì¬ÛÃöªºµ{¦¡½X?
¥i­«·s¶ÇÀɶÜ?

TOP

¦^´_ 4# GBKEE
GBKEE¤jªº·N«ä¬O§ì¸ê®Æªºµ{¦¡½X¶Ü?
À³¸Ó¦³¤~¬Oªü
§Ú©ñ¦bmodule1
¸ê®ÆÂà¬Wª¬¹Ï¬O¥Î¹Ïªí¥h°µªº¡A©ñ¦bsheet2

Book1.rar (10.21 KB)

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-3-25 13:55 ½s¿è

¦^´_ 5# durian77

§Aªº°ÝÃD¬O ·í§A¨ìsheet2 ¬Ý¹Ï®É ·|µo¥Í¿ù»~¶Ü?
¦pªG¬O ¨º¤Ö¤F¤@ÂI(¬õÂI)
Private Sub download() '¦¹µ{§Ç»P Workbook_Open ¦P¦b ThisWorkbook¸Ì
    Dim TimeRange As Range, Rng As Range, R As Range, i%
    With Sheet1     
        Set TimeRange =. [A:A].Find(TimeSerial(Hour(Time), Minute(Time), "00"))
        Set Rng = TimeRange.Offset(, 1).Resize(1, 4)
        For Each R In .Range("D2,D3")
            i = i + 1
            Rng(i) = R
        Next
    End With
    If Time > TimeValue("19:00:00") Then Exit Sub
    Application.OnTime Now + TimeValue("00:01"), "module1.download"
End Sub

TOP

¥»©«³Ì«á¥Ñ linsj ©ó 2011-3-26 21:33 ½s¿è

durian77¤j¤j¡G

½Ð°Ý§A²{¦b¥Î³o¼Ë¤lªº¤è¦¡Åã¥Ü¹Ïªí«á¡A¹q¸£load·|¤£·|«Ü¤j¡H¡@´N¬Oram©Îcpu¦ûªº¤ñ¨Ò·|«Ü¦h¶Ü¡H

¦]¬°¨ì®É­Ô§Ú¤]·Q¥Î³oºØ¤è¦¡°O¿ý¡A¦ý·Q´£«eµû¦ôª¬ªp¡C¡@ÁÂÁ¡C

TOP

¦^´_ 6# GBKEE

¥þ³¡·d©w¤F
¨S°ÝÃD¤F
·PÁÂGBKEE¤j¼ö¤ß¨ó§UÀ°¦£
¸U¤À·PÁÂ

TOP

¦^´_ 7# linsj

linsj¤j§A¦n
§Ú¹q¸£°t³Æ
CPU:amd³æ®Ö2G
RAM:2G

³q±`·|¶}´I¨¹e01¸ò¥ÃÂ×HTS¥[¤W³o­Óexcel©Mmsn
¥Ø«e¬Ý¨ÓCPU¨Ï¥Î²v¦b10%¤W¤U
PF¨Ï¥Î¶q¬ù1.1G
§Úı±o«Ü¶¶
¤£·|¥d
µ¹§A°µ°Ñ¦Ò
¤£¹L³o¥x¹q¸£¥D­n¬O¬Ý³ø»ù¥Î
§Ú¤U³æ¥Î¥t¥~¤@¥x¹q¸£

TOP

ÁÂÁÂ duran¡C
§Ú¬O¥Î http://www.coco-in.net/viewthread.php?tid=7286&extra=page%3D1 ¤U¥h§ïªº¡C
¦]¬°§Ú¹ïexcel¤£¼ô±x¡A©Ò¥H­nªá®É¶¡¤ñ¹ï§Aªº¤èªk¡C

¦]¬°§Ú§ï¦nªºexcel¤µ¤Ñ¶]°_¨Ó¨S°ÝÃD¡C¡@¦ý¦³®É­Ô®É¶¡·|°±¤î¡A¤£¦AÄ~Äò°O¿ý¡A¥u¯à­«¶}excel¡C

§ÚÁÙ¦b·Q¿ìªk¸Ñ¨M¤¤¡C

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD