- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¨º½Ð°Ý¶º¶§À¥i¥H´¡¤JÅܰʪºÈ¶Ü
¹³§Ú§@¤F¤@¸Õºâ,§Æ±æ¦b·~§ÀÅV¥Ü
"¦¹¸Õºâ±ÂÅvxxx¨Ï¥Î"
xxx¬O¨CÓ¤H¤£¦P ...
brabus µoªí©ó 2010-8-27 21:12
§Ú¸Õªºµ²ªG¬O¤£¦æ, (À˵ø -> ¶º¤Î¶§À->¦Ûq¶º[§À] ¹ê»ÚÂIÂI¬Ý´N¥i¥Hª¾¹D¤F)
¥¦¥u¯à©ñ«ü©wªº¸ê®Æ(¶½X¡BÁ`¶¼Æ¡B¤é´Á¡B®É¶¡¡B¸ô®|©ÎÀɦW¡B¯Á¤Þ¼ÐÅÒ[§YSheetName]¡B«ü©wªº¹Ï¤ù)©Î®æ¦¡(¤å¦r¡B¹Ï§Î)
¨ä¹ê§A¥i¥H¦Ò¼{¥Î©T©wªºªí®æ(¨CÓªí®æ½Õ¾ã¦¨è¦n¤@¶),
¦Ó©ñ¹Ï¤ù´N¥Î´¡¤J¹Ï¤ù(±qÀÉ®×)½Õ¦n¦ì¸m,
¦Ü©óÅܰʪº¸ê®Æ´N¥Î¦X¨Ö¤å¦r(CONCATENATE)·f°t°Ñ·Ó(Vlookup)ªº¤è¦¡¤Þ¥Î§Y¥i.
©ÎªÌ§A¤]¥i¥H¦Ò¼{¨Ï¥Î VBA ¨Ó²£¥Í¨C¤@¶ªº¸ê®Æ,
¤£¹L¶º»P¶§Àªº¤º®e¤´À³¬O¨C¤@¶³£¬Û¦P´N¬O¤F. |
|