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

Åܰʬö¿ýªºµ{¦¡

¦pªG¥u­n ¥x«ü , ¥[Åv 2ºØ°Ó«~
¬°¦ó¤£ª½±µ¥Î DDE ´N¦n¤F

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 12:21 ½s¿è

¦^´_ 22# jackyq

1.sheet4¬O§Ú¦Û¤v§ïªº¡A¶Ã®Mªº¡A«¢«¢
2.§Ú¥²¶·½L¤¤§ì¨ú¾ú¥v¸ê®Æ¡A©Ò¥H­n¥Î¦^¸É¸ê®Æªº¤è¦¡
3.§Ú¤£¬O­n§ì¨ú«Ü¦h¾ú¥v¸ê®Æ¡A¦Ó¬O½L¤¤­n§ì¨ú·í¤Ñ¸ê®Æ°µ¹Bºâ¡A§Ú­nªº¸ê®Æ¦³¥x«ü©M¥[ÅvªºtickÀÉ

­ì¥»¬O¥x«ü¸ò¥[Åv³£¥ÎAPI§ì¦ý¬O¦]¬°¸s¯qªº¸ê®Æ¦³»~¡A©Ò¥H§ï¥ÎÅܰʬö¿ýªº¡A¦pªG¸ê®Æ¦³»~¹ï¤U³æ·|¦³¼vÅT

¤£ª¾¹D³o¼ËJ¤j¦³¤F¸Ñ¶Ü??

TOP

¥»©«³Ì«á¥Ñ jackyq ©ó 2016-3-22 12:13 ½s¿è

(1)Sheet4 ¬O§_­ì©lÀɮתºªF¦è
ÁÙ¬O§A¦Û¤v§Ë¥X¨Óªº
(2) Sheet4 §A¬O·Q¦¬¶°¤°»òªF¦è
(3) ©Ò¦³³ø»ù¤£¨Æ³£Åã¥Ü¦b Sheet1, Sheet3 ¤F
(4) §A·Q¦¬¶°«Ü¦h°Ó«~ªº "¾ú¥v' ¸ê®Æ¶Ü?

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 11:50 ½s¿è

¦^´_ 20# jackyq
¬O¨S¿ù¡A¦ý¬O¥i¥H¦P®É°õ¦æ¶Ü??
sheet4°õ¦æAPI,sheet5°õ¦æ§ì»ù®æ??
¥i¬O§Ú­è­è¸Õ¹Lsheet5¨S°Ê§@
©Ò¥HJ¤j¡A§ÚªºÀÉ®×µLªk¾ã¦X¦b¦P¤@­Ósheet¶Ü??
¦]¬°§Ú¨ì®É­ÔÁÙ·|°µ¤@¨Ç¹Bºâ¡A©Ò¥H¾ã¦X¦b¦Psheet¸Ì­±·|¤ñ¸û¦n

TOP

sheet4 ¬O API ªº¥[Åv³ø»ù
sheet5  = Sheets("¥[ÅvDDE" )   ¸g¥Ñ DDE ¬ö¿ý¥[Åv«ü¼Æ

§Ú¬O­nÅý¸ê®Æ³£¥X²{¦bsheet4 -> Åý¥L¥X²{¦b sheet5  ¤]¨S®t§a

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 11:34 ½s¿è

¦^´_ 18# jackyq


    ¤j¤j¡A³o­Ó¬O§ï¦nªº¶Ü??
§Ú¬O­nÅý¸ê®Æ³£¥X²{¦bsheet4¡A«á­±¦h­Ó¥[ÅvDDE¬O??
¤£¤ÓÀ´¤j¤jªº·N«ä

TOP

123_b.zip (215.37 KB)

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 10:27 ½s¿è

¦^´_ 16# jackyq
123.rar (329.21 KB)
J¤j¨ä¹ê§Ú¬O­n±Nªþ¥ó¸Ì­±ªºªF¦è¾ã¦X¦b¤@°_¡A¸Ì­±¦³¸s¯qªºAPI¡A§Ú¬O­nÂ^¨ú¸ê®Æ¡A¦ý¦]¬°¸s¯q¦b¥[Åvªº¸ê®Æ¦³»~¡A©Ò¥H¥[Åvªº³¡¤À§ï¥ÎÅܰʬö¿ýªº¤è¦¡§ì¨ú
¦ý¬O§Ú±Nµ{¦¡µ²¦X¤§«á¥hµLªk°õ¦æ¤F¡A·Q½ÐJ¤jÀ°§Ú¬Ý¬Ý¡A­n«ç»ò§ó§ï¡A§ó·sªº³¡¤À­nºû«ù­ì¥»ªº2¬í§ó·s¤@¦¸¤~¦æ¡A·PÁ¤j¤j

J¤j¤£¦n·N«ä³o¼Ë³Â·Ð§A

TOP

¦^´_ 15# ÂŤÑÄR¦À


    §AªºÀɮ׸̭±ªº    ThisWorkBook

Private Sub Workbook_Open()
Application.RTD.ThrottleInterval = 0
''   Application.Calculation = xlCalculationManual     -> §â³o­Ó¾B¸n±¼«á, ¦sÀɦA­«¶}
End Sub

TOP

¦^´_ 13# jackyq


    ÁÙ¬O¤£¦æ

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD