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

[µo°Ý] dde ³sµ² ¤½¦¡§ó§ï ?

[µo°Ý] dde ³sµ² ¤½¦¡§ó§ï ?

dde ³sµ² =XQKGIAP|Quote!'2317.TW-Name'
·Q§â 2317 ¥ÎA2ªº­È¨ú¥N ,¤£ª¾¦p¦ó§ó§ï?

dde ³sµ² =XQKGIAP|Quote!'2317.TW-Name'
·Q§â 2317 ¥ÎA2ªº­È¨ú¥N ,¤£ª¾¦p¦ó§ó§ï?
t8899 µoªí©ó 2014-11-29 09:38


[C3].Formula="=XQKGIAP|Quote!'" & [A2] & ".TW-Name'"

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-12-3 07:37 ½s¿è
[C3].Formula="=XQKGIAP|Quote!'" & [A2] & ".TW-Name'"
luhpro µoªí©ó 2014-12-2 21:53


§Ú¬O­nª½±µ¦b¤½¦¡¸Ì§ï(ª½±µ®M¥Î)¡A¤£¬O¥ÎVB¥h§ï¤½¦¡

TOP

°Ñ¦Ò, ¬Ý¯à¤£¯à¦Û¦æ®M¥Î¡G
https://tw.knowledge.yahoo.com/question/question?qid=1013050800336
https://tw.knowledge.yahoo.com/question/question?qid=1013032004425

©T©wªø«×¤å¦r¡A¥i¨Ï¥Î¡e¨ú¥N¡f¤èªk¡ã¡ã
¡@

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-12-10 00:21 ½s¿è
§Ú¬O­nª½±µ¦b¤½¦¡¸Ì§ï(ª½±µ®M¥Î)¡A¤£¬O¥ÎVB¥h§ï¤½¦¡
t8899 µoªí©ó 2014-12-3 07:36

´N§Ú©Òª¾ :

¨º·íµM¬O¤£¦æªº°Õ.
§Aªº»Ý¨D¬O¦bÀx¦s®æ¤½¦¡¤ºªº DDE³sµ² ¥iª½±µ°Ñ·Ó¥t¤@Àx¦s®æªº¤º®e°µÅܤÆ,
¥ç§Y¦¹ DDE³sµ²¤½¦¡ ¬O°ÊºAªº,
·í©Ò°Ñ·ÓªºÀx¦s®æ¤º®e¦³²§°Ê(«DDDE³sµ²ªº¸ê®Æ¦³²§°Ê)³o­ÓDDE³sµ²·|¸ò¤§«e¤£¦P,
Ãþ¦üªº°Ñ·Óª«¥iÅܧó¥\¯àÀ³¸Ó¬O¥u¦³ INDIRECT ¨ç¼Æ,
¦ý¥¦«o¨Ã¤£¤ä´©DDE¤½¦¡.

TOP

´N§Ú©Òª¾ :

¨º·íµM¬O¤£¦æªº°Õ.
§Aªº»Ý¨D¬O¦bÀx¦s®æ¤½¦¡¤ºªº DDE³sµ² ¥iª½±µ°Ñ·Ó¥t¤@Àx¦s®æªº¤º®e°µÅÜ ...
luhpro µoªí©ó 2014-12-10 00:16


§Úªº·Qªk¤]¬O¥u¯à¥Î INDIRECT ¡A¦ý¥¢®Ä :-(
§Ú§ï¥Îvb ¥Îreplace °µ ¡A¦]¬°«ö·ÓÅv­È¤j¤p±Æ§Ç,¤@¬q®É¶¡¡A¶·±Æ§Ç¤@¦¸
For Each rng In Range(Cells(i, "b"), Cells(i, "m"))
    rng.Replace What:="!'????", Replacement:="!'" & Cells(i, 1), LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
Next rng

TOP

§Úªº·Qªk¤]¬O¥u¯à¥Î INDIRECT ¡A¦ý¥¢®Ä :-(
§Ú§ï¥Îvb ¥Îreplace °µ ¡A¦]¬°«ö·ÓÅv­È¤j¤p±Æ§Ç,¤@¬q®É¶¡¡A ...
t8899 µoªí©ó 2014-12-10 09:29

§A¥i¥H¦Ò¼{´«­Ó¨¤«×·Q:
1. ¦pªG³æ¯Â¥u¬O¾ã­Óªí®æ¤º®e¶·¨Ì·Ó¬Y¨ÇÄ椺ªº­È°µ±Æ§Ç,
¨º¥u­n«ü©w¦n­n±Æ§Çªº½d³ò´N¥i¥H¤F (¨Ò¦p : Range(Columns(1),Columns(9)).Sort ... ©Î Range(Rows(1),Rows(9)).Sort ...) ,
DDE ¤½¦¡§¹¥þ¤£¥ÎÅÜ,
¦]¬°¥¦·|¬O¾ãÄæ(©Î¦C)¤@°_²¾°Êªº,
­ì¥ý¬O¹ïÀ³­þ¤äªÑ²¼±Æ§Ç«á¤´µMÁÙ¬O·|¹ïÀ³¨º¤äªÑ²¼.

2. ­Y¬O DDE ¤½¦¡¤¤©Ò°Ñ·ÓªºÀx¦s®æ¤º®e¥i¯à·|ÅÜ°Ê,
¨º¥i¥H¦Ò¼{¦b Worksheet_Change ¹ï Target ¦ì©ó¸ÓÄæ(©Î¸Ó¦C)®É,
°õ¦æÃþ¦ü¤W­± 2# ©ÒÁ|¨Òªºµ{¦¡¥h²§°Ê¨ä©Ò¹ïÀ³Àx¦s®æªº DDE ¤½¦¡§Y¥i.

¦n³B¬O°õ¦æ®É¶¡·|ÁYµu, ®ÄªG«o¤£ÅÜ.

TOP

§A¥i¥H¦Ò¼{´«­Ó¨¤«×·Q:
1. ¦pªG³æ¯Â¥u¬O¾ã­Óªí®æ¤º®e¶·¨Ì·Ó¬Y¨ÇÄ椺ªº­È°µ±Æ§Ç,
¨º¥u­n«ü©w¦n­n±Æ§Çªº½d ...
luhpro µoªí©ó 2014-12-10 21:36


ÁÂÁ«ü¾É!

TOP

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