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

[µo°Ý] Yeswin DDE ªº°ÝÃD

[µo°Ý] Yeswin DDE ªº°ÝÃD

¤£ª¾¨ìª©¤W¦³¨S¦³²z°]°ª¤â¦³§Q¥Î¤¸¤jYeswin´£¨ÑªºDDE¥\¯à¦Û¤v¼gExcelÀɤÀªRªº..

§Ú§â¦Û¤v§ë¸ê²Õ¦XªºªÑ²¼³£¾ã¦X¨ìExcelÀɸ̭±, Åý¥¦¦Û°Ê§ì³ø»ù¸òº¦¶^´T¨Ã³]©w¤@¨Ç¦Û§Ú¶i¥Xªº±ø¥ó.
¦ý¬ODDEÄæ¦ìªº®æ¦¡¬O¨Ò¦p=YES|DQ!'2330.Price' ³o¼Ë¤l, ³Q³æ¤Þ¸¹¥]°_¨Óªº¬O¦r¦ê...
©ó¬O¥GÅܦ¨­n¬O§Ú¦³¤QÀÉ­ÓªÑ, ­n§ì»ù®æ, º¦¶^´T, ¦WºÙµ¥¸ê®Æ, Åܦ¨­n¹³¬O=YES|DQ!'2330.Price' , =YES|DQ!'2330.Change', =YES|DQ!'2330.Volume'..... Åܦ¨©Ò¦³­ÓªÑ¥N¸¹¸òÄæ¦ì­n¤@­Ó¤@­ÓÄæ¦ìºCºC§ï

¦]¦¹·Q½Ð°Ý¦³¨S¦³¿ìªk¥HÅܼƪº¤è¦¡, ¨Ò¦p¬Y¤@­ÓÄæ¦ì¿é¤J¥N¸¹¨Ò¦p2330, «á­±DDE´N·|¦Û°Ê±a¤J¥N¸¹µM«á¥h§ì¨ú§Ú«ü©wªº¸ê®Æ©O? ÁÂÁÂ

§Ú¨S¦³ "¤¸¤jYeswin´£¨ÑªºDDE"
¦ý§A¥i¸Õ¸Õ¤U¦C°µªk"
Àx¦s®æA1­È=ªÑ²¼¥N½X
Àx¦s®æB1­È=Price
Àx¦s®æC1­È=Change
Àx¦s®æD1­È=Volume
¦bA2¶ñ¤J 2330
°õ¦æ¤U¦Cµ{¦¡
Sub test()
    Dim Stock As String
    Stock = Range("A2")
    Range("B2").Formula = "=YES|DQ!'" & Stock & ".Price'"
    Range("C2").Formula = "=YES|DQ!'" & Stock & ".Change'"
    Range("D2").Formula = "=YES|DQ!'" & Stock & ".Volume'"
End Sub

TOP

¦^´_ 2# kobo



¦pªG¤£¥Î ¥¨¶°
¦Ó
¬Oª½±µ¥Î¤u§@ªí¤W¨Ï¥Î

TOP

§Ú¥ÎVB6¿é¤J¦r¦êªº¤è¦¡,¿é¤J¨ìexcel.
¤Ó³Â·Ð¤F~
Happy

TOP

§Ú¨S¦³ "¤¸¤jYeswin´£¨ÑªºDDE"
¦ý§A¥i¸Õ¸Õ¤U¦C°µªk"
Àx¦s®æA1­È=ªÑ²¼¥N½X
Àx¦s®æB1­È=Price
Àx¦s®æC1­È ...
kobo µoªí©ó 2012-3-31 11:53



¥i¤£¥i¥H ¦b A1 ¿é¤J ªÑ²¼¥N¸¹ ¦b B1 ¥i¥H¥Î =YES|DQ!'A1.Name'

TOP

A1=2330
B1=INDIRECT("YES|DQ!'"&A1&".Price'")
³o¼Ë¸Õ¸Õ¬Ý
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

A1=2330
B1=INDIRECT("YES|DQ!'"&A1&".Price'")
³o¼Ë¸Õ¸Õ¬Ý
gong µoªí©ó 2012-4-1 10:45



¸Õ¹L¤F  ´N¬O¤£¦æ ¤~·Q°Ý¤j®a
¦³¨S¦³¨ä¥Lªº¤èªk

TOP

¸Õ¸Õ¬Ý Hsieh ¤j¤jªº¤èªk
http://forum.twbts.com/thread-5333-1-1.html

TOP

¸Õ¸Õ¬Ý Hsieh ¤j¤jªº¤èªk
kobo µoªí©ó 2012-4-2 11:31



§Ú¸Õ¹L³o­Ó¤èªk
¥i¬O ¦­¤W¨Æ¬O¥i¥H

¤U¤È­n®»¦¬½L»ù «o¤£¦æ¤F
¤£ª¾¹D«ç»ò¦^¨Æ

TOP

¥ÎEvaluate¨ç¼Æ©w¸q¦WºÙ§ì¨ìDDEªº­È¬O¤£·|Åܰʪº(§Y®É)¡A¶È¯àÅã¥Ü¿é¤J¤½¦¡§¹¦¨·í®Éªº­È ´N¤£¦AÅܤF¡C

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD