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

[µo°Ý] ¤ñ¹ï¨Ó·½«á²Å¦X±ø¥ó«h¶K¤W¸ê®Æ

[µo°Ý] ¤ñ¹ï¨Ó·½«á²Å¦X±ø¥ó«h¶K¤W¸ê®Æ

¥»©«³Ì«á¥Ñ PJChen ©ó 2019-12-8 20:45 ½s¿è

Dear,
VBA³]¦b Macro.xlsm
¨Ó·½ÀÉ ³Ì·s®w¦s.xlsx
¥ØªºÀÉ ¸ê®Æ§¨:1.¤é¯Z²z³f´«ºâªí¡K¦³¦h­ÓÀÉ®×,¥Ø«e´ú¸Õ¥u©ñ¤F3­Ó
­ì¨Óªºµ{¦¡¬O§Q¥Î¤½¦¡,¦A­È¤Æ
¥i¬O¶]ªº³t«×¦³ÂI¡K.ºC¡I
§Ú·Q§ï¦¨....µ{¦¡ªº¥\¯à»Ý¨D¬°:
²Å¦X¸ô®|³]©wªºÃöÁä¦r"*Drink*,´N¥´¶}ÀÉ®×Dir(Path & "*Drink*.XLSX")
¥H¨Ó·½ÀɪºFÄæ&AI3:AY3¥h¤ñ¹ï¥ØªºÀɪº¸ê®Æ§¨¤ºÀÉ®×
³o2­Ó±ø¥ó²Å¦X,´N§âAI4:AY62ªº¬Û¹ïÀ³¸ê®Æ(¥u¶K­È,¤£­n¤½¦¡¡B®æ¦¡)¶K¨ìÀɮ׸s¤¤ªºLÄæ
¥ØªºÀÉ ¸ê®Æ§¨¤ºªºÀɮפu§@ªí¥H¤é´Á©R¦W
¶Kªº®É­Ô­n¥H·í¤Ñ¤é´Á¬°¥D,¨Ò¦p:¤µ¤Ñ¬O8¤é,¸ê®Æ´N¶K¦b"8.sheet"
µM«áÂI¿ï"9.sheet"¦sÀÉÃö³¬
½d¨ÒVBA¬O¨ä¤¤¤@­Óµ{¦¡
¨ä¥LÀɮפ]¦³§â¸ê®Æ¶K¦bD+1ªº¤u§@ªí¤ºªº,¦sÀɮɴN­nÂI¿ïD+2
¦]¬°¨ä¥LÀɪº¸ê®Æ¤£¨£±o³£¶K¦b¦P­ÓÄæ¦ì,©Ò¥H¥ý¥Î¨ä¤¤¦PÄæ¦ìªº¨Ó»¡©ú.
·Q½Ð°Ý¨Ì­ì¨Óªºµ{¦¡¥i¥H«ç»ò§ï·|¶]±o§Ö¨Ç?
µù¡G¨Ó·½ÀÉ ³Ì·s®w¦s.xlsx ¤u§@ªí¤ºAI3:AY3ªº¦P¦WºÙªíÀY¦³³\¦h­«½Æªº,¥u¯à¥Î³o­Ó½d³òªº¦WºÙ¥h¤ñ¹ï¥ØªºÀɪº¸ê®Æ§¨¤ºÀÉ®×
VBA_¤ñ¹ï¨Ó·½_¶K¤½¦¡.rar (319.78 KB)

¸É¥R¡G
¥Øªº¸ê®Æ§¨¤ºªºÀɦW »P ¨Ó·½ÀÉ ³Ì·s®w¦s.xlsx ¤u§@ªí¤ºAI3:AY3ªºªíÀY
·|¦³¬Û¦Pªº¦r
¨Ò¡G·x·x1¡B´ò¤f1....
¤]´N¬O¥Øªº¸ê®Æ§¨¤ºªºÀɦW·|¥]§t AI3:AY3ªíÀY¦r¦ê
¤ñ¹ï®É¥i¥H¥ÎÀɦW§@¬°¹ï¶H
¦A¤ñ¹ï¥´¶}¥ØªºÀɤ§«áªº®Æ¸¹§Y¥i

TOP

¥i¯à¥Î¤å¦r´y­zÅã±o¤Ó¹L½ÆÂø....
¤£¹L³o­Óµ{¦¡¥u¬OºC,©Ò¥H§Ú·Q§ï¼g¥¦
§Ú·Q§ïªº³¡¥÷¥u¦³¤G­Ó¦a¤è
1) ¥Î "¥Øªº¸ê®Æ§¨" ¤ºªºÀɦW ¤ñ¹ï "¨Ó·½ÀÉ" ³Ì·s®w¦s.xlsx ¤u§@ªíªíÀYAI3:AY3¦WºÙ,
     "¥Øªº¸ê®Æ§¨" ¤ºªºÀɦW ³£¥]§t "¨Ó·½ÀÉ" ³Ì·s®w¦s.xlsx ¤u§@ªíªíÀYAI3:AY3¦WºÙ
2)  ÀɦW¦³³¡¥÷¬Û²Å,«h¤ñ¹ï®Æ¸¹¨Ã¶K¤W¬Û¹ïÀ³ªº¸ê®Æ
EX: Drink_´ò¤f1.xlsx....ÀɮצWºÙªº"´ò¤f1"¬O²Å¦X"¨Ó·½ÀÉ" ³Ì·s®w¦s.xlsxªºAR3«h
¤ñ¹ïDrink_´ò¤f1.xlsxªº®Æ¸¹,®Æ¸¹¬Û²Å,«h¶K¤WAR4:AR©³¬Û¹ïÀ³ªº¸ê®Æ

¥i§_À°¦£³o¤G¬qµ{¦¡ªº¼gªk??

TOP

¥i¥H¥ýÁY´î¤@¤U EXCEL ªí ªº¸ê®Æ¥ý¶Ü  

·Pı¸ê®Æ¦³ÂI¹L¦h  ¦³ÂIÃø¬Ý²M·¡

TOP

¦^´_ 4# adrian_9832
¦]¬°¥­¤é¥Îªºªí®æ½g´T´N¬O«Ü¤jªº,¤£»Ý¥Î¨ìªº§Ú´NÁôÂäF,¦ý§Ú¤£·Q§R°£¥¦, ¦]¬°©È§R¤F,¨ì®É­n§ïµ{¦¡,¤S§ï¿ù....

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD