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

[µo°Ý] ¤¸¤jRTD°ÝÃD

[µo°Ý] ¤¸¤jRTD°ÝÃD

¥»©«³Ì«á¥Ñ blue2263 ©ó 2016-10-23 13:48 ½s¿è

½Ð±Ð¤j¤j

°ÝÃD1:§Ú­n¦bA1Àx¦s®æ,¿é¤J¤¸¤jRTD¨ç¼Æ®É,µ{¦¡¤£Åý§Ú«Ø¥ß,
03µ{¦¡½X,·|¥X²{»yªk¿ù»~°T®§,½Ð±Ð­n¦p¦ó­×§ï?
  1. Sub ´ú¸Õ
  2.    With ThisWorkbook.Worksheets("X")
  3.      .range("a1") =  "=RTD("money.excel", , "TXF1", "Expire")  'A1Àx¦s®æ,¿é¤J¤¸¤jRTD¨ç¼Æ
  4.   End With
  5. End Sub
½Æ»s¥N½X
°ÝÃD2: ¦³¿ìªkª½±µ³]©wÅܼƨӱµ¦¬RTD & DDEªº¸ê®Æ¶Ü?
¸ÑÄÀ­ì¦], ²{¦b°µªk¬OVBA¥á¥X¨ç¼Æ¤½¦¡->Àx¦s®æ±µ¦¬¸ê®Æ«á->VBA®»¨ú¸ê®Æ->«á¦A°µ«áÄò¸ê®Æ³B²z
§Ú·QÅܼƦpªG¥i¥H,ª½±µ±µ¦¬¸ê®Æªº¸Ü,´N¯à¤Ö¦h­Ó¨BÆJ( ¥á¨ìÀx¦s®æ->±µ¦¬¸ê®Æ->¦A®»¨ú¸ê®Æ)
¦]¦¹·Q°Ý¬O§_¦³?Åܼƥiª½±µ±µ¦¬RTD DDE ¸ê®Æªº¤èªk

Áٽаª¤â¤j¤j,À°¦£¸Ñµª,·P®¦ÁÂÁÂ!!

½Ð°Ý¤j¤j¤§«e°ÝÃD¸Ñ¨M¤F¶Ü¡H§Ú¤]¹J¬Û¦P°ÝÃD

TOP

¦^´_ 15# c_c_lai
§Úªº°ÝÃD¦³®É¤~·|¥X²{,§Ú·Q¥i¯à¨ç¼Æ¸ê®Æ¤Ó¦h¦³Ãö§a?§Úµ{¦¡¦³°µ¨Ç§ó§ï,§ï¦n§Ú¦A¦h´ú´X¤Ñ,¦p¦³°ÝÃD¦A´£¥X
·PÁÂC¤j¼ö¤ßÀ°¦£

TOP

¦^´_ 14# blue2263
´£¨Ñ°Ñ¦Ò¡A§Ú±µÄ² RTD ®É¬q«Üµu¡A¤§«á«K¦¬¤â¤F¡C
RTD¨Ï¥Î½d¨Ò.rar (18.76 KB)

TOP

¥»©«³Ì«á¥Ñ blue2263 ©ó 2016-10-26 21:03 ½s¿è

½Ð±ÐC¤j,¦p·Q½T«ORTD¼Æ­È¦³¦b§ó·s,
¤£ª¾¦³¨S¦³»PRTD·¾³qªº,¼Æ­È§ó·sªºµ{¦¡½X(Ãþ¦ü­«·s¾ã²z)

TOP

¦^´_ 12# c_c_lai
¦^´_c¤j,°ÝÃD±¡ªp,¦³®É¤~·|¥X²{
°ÝÃD¹Ï¤ù,¦³µù©ú¬O¼ÒÀÀµe­±,¤§«e°ÝÃD¸ê®Æ¤v§R°£

TOP

¦^´_ 11# blue2263
A1.png
2016-10-26 08:37

A2.png
2016-10-26 08:37

TOP

¦^´_ 8# c_c_lai
C¤j¤£¦n·N«ä,§Ú¦A§â¤£¨Ç¤£¬Û¤zªº¼Ò²Õ¤Îµe­±§R°£
½Ð¬d¦¬¤U­±¹ÏÀÉ,ÁÂÁÂ!!
´Á³f°O¿ý .rar (732.08 KB)

TOP

¦^´_ 8# c_c_lai
¦^´_c¤j
(b¥Dµe­±)¼Ò²Õ,½Ð¤£­n¬Ý,¥D­n°ÝÃD¬O¦ba°O¿ý¼Ò²Õ

TOP

¹ê»Ú°ÝÃDªº±µ¦¬¸ê®Æ,§Ú¤v§R°£
¤U¹Ï¬°¼ÒÀÀ°ÝÃD1µe­±
°ÝÃD±¡ªp1.png
2016-10-25 19:18


°ÝÃD2,¬O8:45~11:30,°O¿ý³£¥¿±`,11:30¥H«á¦¨¥æ¶q´N°±¤î¼W¥[

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD