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

[µo°Ý] DDE°O¿ý¸ê®Æ¨D§U

¦³Ãöexcel¦Û°Ê¬ö¿ý§Y®É¸ê®Æ

¦U¦ì«e½ú­Ì¦n¡A¤p§Ì¦³excel¤Wªº°ÝÃD·Q½Ð±Ð¤j®a¡A¦Û¤v¥»¨­¨S¤°»òexcelªº°ò¥»¥\¡A©Ò¥H·Q½Ð¤j®aÀ°À°¦£

§Ú¦³¨Ï¥Î¸s¯q¶W¯ÅĹ®a"¶×¥XEXCEL"¥\¯à¡A¥i¥H±N½L¤¤¸õ°Ê¸ê®Æ¶×¥X¨ìEXCEL¤¤¡A§Ú¶×¥Xªº¶µ¥Ø¥D­n¦³´Á³fªº©e¶R¤f¼Æ ©e½æ¤f¼Æ ©e¶Rµ§¼Æ ©e½æµ§¼Æ ©e¶R§¡¤f ©e½æ§¡¤f¡A¦ý³o¬O§Y®É¸ê®Æ¡A¬O·|¤@ª½¸õ°Êªº

½Ð°Ý§Ú¦p¦ó±N¥Lªº¸ê®Æ¬ö¿ý¤U¨Ó¡A¦b¨Ò¦p0850¡A0855¡A0900¡A0905µ¥¡A¨C¹j¤­¤ÀÄÁ«K¦Û°Ê±N¸ê®Æ«O¦s¬ö¿ý¤U¨Ó?

§Ú¸Ó°µ­þ¨Ç°Ê§@?

TOP

¦^´_ 1# n8975067
¥»µ{¦¡°Ï¤w¦³³\¦h¬ÛÃöªº°Q½×,½Ð¦h¦h¸Ô¬Ý
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

Sub updateFollow()
  
       Sheet1.Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[a2]
       Sheet1.Range("b" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[b2]
       Sheet1.Range("c" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[c2]

End Sub

­è¦n§Ú¤]¬O³o´X¤Ñ ¤~ª¦¤å¾Ç·|ªº~~

TOP

Sub TimePlus1()
         '¨C¤­¤À©I¥s ¤@¦¸
         Application.OnTime Now + 300 / 86400#, "UpdateFollow"
      
End Sub

§Æ±æ¹ï§A¦³À°§U

TOP

¦U¦ì«e½ú¡A³o¨Çµ{¦¡»y¨¥ªº¯à¤O¡A§ÚÁͪñ©ó¹s¡A¤µ¤Ñ´c¸É¤F¤@¨Ç¬ÛÃöª¾ÃÑ¡A³o¨Çµ{¦¡»y¨¥¬O­n©ñ¸m¦b"¥¨¶°"¤º¶Ü?

TOP

¦^´_ 5# n8975067


    «öIbt¤j¤jªº¤èªk¥i¥H¼g¦¨¤@­Ó¥¨¶°¡A¤£»Ý­n¨â­Ó§a¡I§Ú¤]¤£À´¬O¤£¬O³o¼Ë¼g¥i¥H¡C
  1. Sub updateFollow()
  2.   
  3.        Sheet1.Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[a2]
  4.        Sheet1.Range("b" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[b2]
  5.        Sheet1.Range("c" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[c2]


  6.          '¨C¤­¤À©I¥s ¤@¦¸
  7.          Application.OnTime Now + 300 / 86400#, "UpdateFollow"

  8. End Sub
½Æ»s¥N½X
¤H¥Í¥u¦³¤T¤Ñ¡A¥u¦³¬¡¦b¤µ¤Ñ³Ì½ñ¹ê

TOP

¦^´_ 5# n8975067
³o¸Ì¥ý§âª±¤@¤U

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ n8975067 ©ó 2013-4-14 11:27 ½s¿è

Sheet1.Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[a2]
¦³ÃC¦âªº³¡¤À¬O·|¥]¸Ø¾ã­Óaªº¸ê®Æ¶Ü¡AÁÙ¬O»¡­n³]µ{"a2"³o¼Ë¡A§Ú¥u·Q­n·|¸õ°Êªº¼Æ¦r³¡¤À

TOP

¤¤¤å¤]­n¥´¶i¥h¶Ü?
¤µ¤Ñ¸Õ¤F¤W­±ªº»yªk¡Aµ²ªG¨S¿ìªk

TOP

¦^´_ 6# barrykuo
¤j¤j§A¦n¡A³o­Óµ{¦¡½X§Ú®M¥Î¶i¥h«á¡A¦b¶}½L®É¶¡¶}±Ò¡A¨S¦³¥ô¦ó°Ê§@¡A§i¶D§Ú¦¹±M®×¥¨¶°¤w³Q¼È¤î¡A³o¬O¤°»ò·N«ä?

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD