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

[µo°Ý] ½Ð°Ý¦p¦ó¦bEXCEL¤¤¨C­¶´¡¤J¤½¥qªºLOGO

[µo°Ý] ½Ð°Ý¦p¦ó¦bEXCEL¤¤¨C­¶´¡¤J¤½¥qªºLOGO

½Ð°Ý¦p¦ó¦bEXCEL¤¤¨C­¶´¡¤J¤½¥qªºLOGO©O,¤é´Áªº³¡¤À¤]¶¶«K½Ð±Ð,

­¶­º/­¶§À
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¨º½Ð°Ý­¶­º­¶§À¥i¥H´¡¤JÅܰʪº­È¶Ü
¹³§Ú§@¤F¤@¸Õºâ,§Æ±æ¦b·~§ÀÅV¥Ü
"¦¹¸Õºâ±ÂÅvxxx¨Ï¥Î"
xxx¬O¨C­Ó¤H¤£¦Pªº¦W¦r,¥i¥Hexcel¥Îvlookup¬d¸ß
jeason

TOP

¨º½Ð°Ý­¶­º­¶§À¥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.

TOP

¤F¸Ñ¤F
§Ú¦A¸Õ¸Õ¬Ý
ÁÂÁ§A ªº¦^ÂЮ@
jeason

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD