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

[µo°Ý] ¤j®a¦n , ½Ð±ÐÃö©óDDE¦Û°Ê´«¦æ»P¤@¨Ç°ÝÃD

[µo°Ý] ¤j®a¦n , ½Ð±ÐÃö©óDDE¦Û°Ê´«¦æ»P¤@¨Ç°ÝÃD

¤j®a¦n , ¤p©f¦]¤u§@»Ý­n­è¶}©l¾Ç²ß Excel :P
°Ñ¦Ò¤F ³o½g «á°µ¥X¤F¤j·§·Q¹F¦¨ªº»Ý¨D (½Õ¤F¦n¤[ ><)
¦ý¤S¸I¤W¤@¨Ç°ÝÃD
³oÃäªþ¤W¹ÏÀµ½Ð c_c_lai ¤jÀ°¦£ ><


¥t¥~ÁÙ¦³´X­Ó°ÝÃD«_¬N½Ð±Ð¤j¤j­Ì ~
¥xªÑªº¤j½L¤£¬O¦³¤À¹q¤l¡Bª÷¿Ä¸ò¶Ç²£¶Ü?
¨º§Ú­n§â¥¦­Ìªº¦¨¥æ¤ñ­«§ì¨ì Excel À³¸Ó«ç»ò§ì , §Ú¦ÑÁó¬O¥Î¸s¯q¶W¯ÅĹ®a³o®M
­n§ì¥X¨Ó¹³
¹q¤l 60%
ª÷¿Ä 20%
¶Ç²£ 10% ³o¼Ë ><

µM«á´N¬O¦pªG»¡§Ú·Q­n§ì B,2 ³oÄ檺 "±q¶}½L¨ì¥Ø«eªº³Ì°ª­È»P³Ì§C­È"
À³¸Ó­n«ç»ò¼g©O ? ><

©êºp ~ °ÝÃD¦³ÂI¦h >< ÁٽЦU¦ì¤j¤jÀ°À°¤p©f¤F :'(
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

¦^´_ 1# saleen
©p§â Excel À£ÁY¦¨ .WAR Àɤ§«á¤W¶Ç (¦p°j¯¾°wªºªþ¥ó)¡A
¹ê»Ú¬Ý¤F©pªº¤å¥ó«á¦AµûÂ_¡C

TOP

c_c_lai ¤j½Ð¬d¦¬ :)
½d¨Ò¥[¥Ø«eµ²ªG.rar (186.47 KB)
·PÁÂ :'(
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2013-6-5 13:56 ½s¿è

¦^´_ 3# saleen
©p¬ö¿ý¨Cµ§¸ê®Æªº®É¬q¬O¦h¤[¡H ¨C¤@¬í¡B¨C¤G¤Q¬í¡B©Î¬O¨C¤@¤ÀÄÁ¡H
¨C¦¸¸ê®Æ¼g¤J®É¡A§¡Åã¥Ü¦b²Ä¤@µ§¸ê®Æ¦C¤W¡A¥ç§Y¤§«eªº¸ê®Æ¿ý§¡©¹¤U²¾¤@¦æ¡H
³Â·Ð©p±N»Ý¨D»¡©ú²M·¡¡A¦P®É¨CÄæ­n¹ïÀ³ªº¸ê®Æ¨Ó·½¤]½Ð´y­z¤@¤U¡C
P.S.  ½Ð¦^ÂЮɡA°È¥²ÂI¿ï "¦^ÂÐ" ¶s¡A§_«h¦p¨S¥J²ÓÂsÄý¬O¤£ª¾¹D¦³ "«H¥ó®ø®§" ªº¡C

TOP

¦^´_ 4# c_c_lai

c_c_lai ¤j©êºp >"<
¥H«á·|°O±o¥Î¦^ÂЫö¶sªº
§Ú°O¿ýªº®É¶¡¤@¼Ë¬O¤­¤ÀÄÁ¤@¦¸§r
²Ä¤G¦æ~¬Oªº´N¬O«e¤@µ§¸ê®Æ¤U²¾
Ãö©ó»Ý¨D´N¬O :
¥H E4 ¬°¨Ò
E4 = B4 - B3
F4 = C4 - C3
G4 = D4 - D3
E5 = B5 - B4

¦ý¦]¬°¥H­ì´«¦æµ{¦¡¨Ó¶]¥¦¬O§â A2~J2
¨C¹j5¤À©¹¤U¤@¦æ°O¿ý
°ÝÃD¬O¦b¤@¶}©l®É E2 F2 ¸ò G2 ¬O¨S¿ìªk¦³¸ê®Æªº (¦]¬° B C D ªº²Ä¤G¦æ¨S¿ìªk´î²Ä¤@¦æ , ²Ä¤@¦æ¬O¤¤¤å , ¦Ó E F G ªº²Ä¤T¦æ¦]¬°¤@¶}©l²Ä¤G¦æ¨S¸ê®Æ¤]¨S¿ìªk¥h´î¥¦)
©Ò¥H E F G ©¹¤U´N·|¤@ª½¬OªÅ¥Õ

¤£ª¾¹D³o¼Ë¸ÑÄÀ°÷¤£°÷²M·¡ ><
·PÁÂ :Q
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

¦^´_ 5# saleen
´Á«ü_001.xlsm
  1. Sub updateFollow()
  2.     Dim Rng As Range
  3.     If (TimeValue(Now) < TimeValue("08:45:00") Or TimeValue(Now) > TimeValue("13:45:00")) Then Exit Sub
  4.     With ¤u§@ªí1
  5.         Set Rng = .Range("A" & .Range("A" & .Rows.Count).End(xlUp).Row + 1).Resize(1, 12)
  6.         Rng(1) = "=XQTISC|Quote!'FITX06.TF-Time'"
  7.         Rng(2) = "=R2-Q2"
  8.         Rng(3) = "=X2-W2"
  9.         Rng(4) = "=T2-U2"
  10.         Rng(5) = "=IF(ISNUMBER(R[-1]C[-3]),RC[-3]-R[-1]C[-3],"""")"
  11.         Rng(6) = "=IF(ISNUMBER(R[-1]C[-3]),RC[-3]-R[-1]C[-3],"""")"
  12.         Rng(7) = "=IF(ISNUMBER(R[-1]C[-3]),RC[-3]-R[-1]C[-3],"""")"
  13.         Rng(8) = "=Y2"
  14.         Rng(9) = "=Z2"
  15.         Rng(10) = "=Z2-Q5"
  16.         Rng(11) = "= AA2 - AB2"
  17.         Rng(12) = "=AD2"
  18.         Rng.Value = Rng.Value
  19.         Rng(1).NumberFormat = "hh:mm:ss"
  20.     End With
  21.     If timerEnabled Then Call timerStart
  22. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  c_c_lai

c_c_lai ¤j©êºp >"<
¥H«á·|°O±o¥Î¦^ÂЫö¶sªº
§Ú°O¿ýªº®É¶¡¤@¼Ë¬O¤­¤ÀÄÁ¤@¦¸§r
²Ä¤G¦æ ...
saleen µoªí©ó 2013-6-5 15:22

E¡BF¡BG Äæ­È¬O B¡BC¡BD  (·í®Ú - «e®Ú) ¡H
½Ð¼á²M¤½¦¡¬O§_¦p¦¹¡H

TOP

¦^´_ 7# c_c_lai


¬Oªº ~ ´N¬O·í«e´î¤W¤@­Ó ><
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

¦^´_ 6# GBKEE


    ·PÁÂ GB ¤j
¤p©f²{¦b¨Ó¸Õ¸Õ¬Ý >"<
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

¦^´_ 8# saleen


    ³oÃ仡ªº¦³ÂI¤£²M·¡ ><
À³¸Ó¬O»¡¤W¤@µ§ªº°O¿ý´î¥h¤W¤W¤@µ§ªº°O¿ý
°ÝÃD´N¦b²Ä¤@µ§¬O¨S¦³¤W¤@µ§ªº©Ò¥H¨S¿ìªkºâ¥X
¤p©f¦b¦¹¦V¦U¦ì¤j¤j¨D±Ð¤F Orz

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD