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

[µo°Ý] ¨ú¦r¦êµ¥°ÝÃD¡C

[µo°Ý] ¨ú¦r¦êµ¥°ÝÃD¡C

¤j®a¦n,§Ú¦³¤T­Ó°ÝÃD·Q½Ð±Ð¤j®a¡C

1. °²³]A2¦ÜA10 ¦³¸ê®Æ,¦ÓB2:B10 ¬O¸ê®Æ¬°¥H¤U,


SIZE1: one size
SIZE1: XS
SIZE1: S
SIZE1: M
SIZE1: L
SIZE1: XL

½Ð°Ý¦p¦ó¨úSIZE1: ¤§«áªº¸ê®Æ,·í¨ú§¹¤§«á¦b¦P¤@Äæ±oµ²ªG¡C


one size
XS
S
M
L
XL

¨Ò¦pB2 ¬OSIZE1: one size, ¤§«á­ì®æÂন one size ³o¼Ë¡C

¦]¬°¸ê®Æ¦³¦h¦³¤Ö,BÄæ¨ìDÄæ³£¬O³o¼Ëªº®æ§½ ,½Ð°ÝÀ³¦p¦ó¥ÎVBA °µ¡C



2.¥t¥~¤@­Ó°ÝÃD¬O,¥ÑQ28¶}©l¨ì§À¦³¸ê®ÆªºÀx¦s®æ¬°¼Æ¦r,­n±N¨C­ÓÀx¦s®æ¦Û°ÊX2 ¦A­ì®æ±o¥Xµ²ªG¡C

3.¦p¦ó±N¥þ³¡¤w¸g¥´¶}¤Fªº¬¡­¶Ã¯¥þ³¡¦Û°Ê¦C¦L¥X¨Ó,¦Ó¨C­Ó¬¡­¶Ã¯¥u¦³¤@­Ó¤u§@ªí,¦Ó¨C­Ó¤u§@ªíªº¦WºÙ³£¬O¤@¼Ëªº¡C

ÁÂÁÂ

¤j®a¦n,§Ú¦³¤T­Ó°ÝÃD·Q½Ð±Ð¤j®a¡C
...

¦p¦ó±N¥þ³¡¤w¸g¥´¶}¤Fªº¬¡­¶Ã¯¥þ³¡¦Û°Ê¦C¦L¥X¨Ó,¦Ó¨C­Ó¬¡­¶Ã¯¥u¦³¤@­Ó¤u§@ªí,¦Ó¨C­Ó¤u§@ªíªº¦WºÙ³£¬O¤@¼Ëªº¡C

stephenlee µoªí©ó 2019-11-2 16:20
  1.   For Each a In Workbooks
  2.     a.Sheets(1).PrintOut
  3.   Next
½Æ»s¥N½X

TOP

~~¨ú¥N~~
[B:D].Replace "*: ", "", Lookat:=xlPart

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD