¦p¦ó °»´ú DDE §Y®É³ø»ùªº ©³¼h °ò¦§Þ³N
- ©«¤l
- 82
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 112
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-3
- ³Ì«áµn¿ý
- 2020-9-21
|
¦^´_ 1# sjgau
¬Ý§¹¤F¾ã½g¤å³¹
³Ì¤£¸Ñªº¨ä¹êÁÙ¬O³o¬q
¦p¦ó¥Î¡H ¤ñ·Q¹³ÁÙn³Â·Ð¡C §A¥²¶·¥ýµn°O©Ò·Qn³B²z§t DDE Link CELL ªº¦r¦ê¡AµM«á¦A©e°U¥æµ¹¨Æ¥ý¼g¦nªº VBA ¥¨¶° (Marco) ¨Ó³B²z¡C¦p¤U¡G
ActiveWorkbook.SetLinkOnData _
"CATDDE|'STOCK2330 '!Volume", _
"my_Link_Update_Macro"
²Ä¤@ӰѼƬO DDE Link ªº¦r¦ê"¡G²Ä¤GӰѼƴN¬O¥¨¶°ªº¦WºÙ¡C
°O±o¡A¬On§âȱoÃöª`ªº DDE CELL ¤@Ó¤@Ó§Q¥Î¸Óµ{§Ç¨Óµn°O¡AY¬On¥þ³¡ªº CELL ³£nµn°O¡A¨º»ò°Ñ¦Ò¦p¤Uªº¼gªk (refer. DDE Link Change Event¡C)¡G
«ÂI¬O·Q¬Ýì¤å ¤WzªºDDE Link Change Event ³sµ²¤w¸g¥¢®Ä¤F
½Ð°Ýª©¥D¤F¸Ñ¨Ï¥Î¥¨¶°±Ò°ÊtickÅܤƪº³oÓ³¡¤À¶Ü?? |
|
|
|
|
|
|
- ©«¤l
- 82
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 112
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-3
- ³Ì«áµn¿ý
- 2020-9-21
|
¦^´_ 3# sjgau
ªO¤j
³oÓ·N«ä¬O §A±NDDE ·|§ó§ïªº¸ê®Æ©ñ¦bA1¸Ì±
·í¼Æ¦r¦³Åܰʪº®ÉÔ¡A¥L´N·|±qA2>A3>A4 ³o¼Ë¤l°O¿ý¤U¥hªº·N«ä¶Ü.. |
|
|
|
|
|
|