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

[µo°Ý] ±Ndde³sµ²ªºÅܰʸê®ÆÀx¦s¦bExcelªº°ÝÃD

[µo°Ý] ±Ndde³sµ²ªºÅܰʸê®ÆÀx¦s¦bExcelªº°ÝÃD

ªþ¥ó¬O§Ú¥Îdde³sµ²¬Ý½L³nÅé¡A·í¥x«ü´Á¨Cµ§¥X²{10¤f¥H¤Wªº³æ¶q®É´N¬ö¿ýÀx¦s¤U¨Ó
¦ý¬O«Ü©_©Çªº¬O¡A·í10¤f¥H¤Wªº¼Æ¦r¥X²{®É¡A¥¦·|­«½Æªº¬ö¿ý¦n´Xµ§¬Û¦Pªº¸ê®Æ¡A¨S¦³¤j³æ¥X²{®É¤]·|§â0ªº¼Æ¦rÀx¦s
«ç»ò­×§ï¤]¨S¦³¥Î¡A¤£ª¾¨ä¥L¤H¬O§_¤]¦³¬Û¦Pªº°ÝÃD
Ãø¹D¦³¥i¯à¬Odde¼Æ¾Ú¨Ó·½ªº°ÝÃD¶Ü? ¦³¤°»ò¤èªk¥i¥H¸Ñ¨M©O?
ddetx.zip (8.13 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-12-10 16:30 ½s¿è

¦^´_ 1# bubu1019

§PÂ_[M2]>=10¤~¬ö¿ý
DDE¤u§@ªí¼Ò²Õ
  1. Private Sub Worksheet_Calculate()
  2. MyTime = Time
  3. If Sheets("DDE").[M2] >= 10 Then Sheets("¬ö¿ý").[B65536].End(xlUp).Offset(1).Resize(, 2) = Array(MyTime, Sheets("DDE").[M2])
  4. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¤j¤jªºÀ°¦£¡A¤µ¤Ñ´ú¸Õªºµ²ªG
«Ü©_©Çªº¬Oµo²{¥¦¦ü¥GÁÙ¬O¤£ºÞ³æ¶qªº­­¨î¡A¥u­n³æ¶q¦³ÅÜ°Ê´NÀx¦s
¦Ó¥B¦³®É·|³sÄòÀx¦s¦P¤@µ§¸ê®Æ(¦pªþ¥ó)¡A¹ê¦b·d¤£À´¬O«ç»ò¤@¦^¨Æ

test.rar (9.62 KB)

TOP

¦^´_ 3# bubu1019
¼Ó¤Wªºµ{¦¡½X§Ñ°O±N<>MyTime§R°£¤w­×¥¿
¥u­nDDE¤u§@ªí¤£³sµ²¨ì°O¿ý¤u§@ªíÀ³¸Ó´N¤£·|¥X²{2¦¸¬ö¿ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  bubu1019
¼Ó¤Wªºµ{¦¡½X§Ñ°O±NMyTime§R°£¤w­×¥¿
¥u­nDDE¤u§@ªí¤£³sµ²¨ì°O¿ý¤u§@ªíÀ³¸Ó´N¤£·|¥X²{2¦¸ ...
Hsieh µoªí©ó 2011-12-10 16:37


­ì¨Ó¦p¦¹¡A§Ú·Q³o¼ËÀ³¸Ó´N¨S°ÝÃD¤F¡A·PÁÂHsiehªº¨ó§U¡A¦³³Â»¶¾Ç¶é¦b¯u¬O¤Ó´Î¤F

TOP

¦^´_ 5# bubu1019


   §Ú¸Õªºµ²ªG À³¸ÓÁÙ¬O·|¥X²{¦hµ§¬ö¿ýªº°ÝÃD§a
devidlin

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD