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

[µo°Ý] Åý¤½¦¡ªº­È,ª½±µ±a¤JÀx¦s®æ

¦^´_ 80# ­ã´£³¡ªL

ÁÂÁ­ã¤j
¥i¥H¥¿±`¹B§@¤F

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2021-4-18 18:43 ½s¿è

¦^´_ 25# ­ã´£³¡ªL
­ã¤j¦n,
³o­ÓÀÉ©µÄò¤§«e¼gªºµ{¦¡,§Q¥Î"«~¦W"&"¦X­p"¤§¶¡ªº¦C¼Æ°µ¨ÇÅܤÆ,½ÐÀ°¦£¬Ý¤U...·PÁ¡I ²z³f³æ_Åý¦C¼Æ¬Û¦P.rar (236.66 KB)

·QÅý·s²z³fÀÉ,»P±M®×²z³f¤ºªº¦P¼ËÃöÁp¦r,¦C¼Æ¬Û¦P,
ÃöÁp¦r»PÀɦWªºÃö«Y,¦C¦bMacro_2.xlsmªºACÄæ,¥¼¨Óµ{¦¡¤]©ñ³o¸Ì,
ACÄæÃöÁp¦r¦b"±M®×²z³f" ªºBÄæ,¥i¥H§ä¨ì§¹¥þ¬Û¦Pªº¦r
§Ú·Q­n§Q¥ÎÃöÁp¦r,§ä¨ì¹ïÀ³ªº·s²z³f³æ
EX:
1) Macro_2.xlsmªºACÄæ,²Ä¤@­ÓÃöÁp¦r:·x·x3
2) "±M®×²z³f" BÄæ§ä¨ì·x·x3,"«~¦W"&"¦X­p"¤§¶¡¦C¼Æ=33¦C(¥]§tªÅ¥Õ¦C)
3) ¥´¶}¹ïÀ³ÀɦW"²Î­Ü_·x·x.xlsx",¤ñ¹ï"«~¦W"&"¦X­p"¤§¶¡¦C¼Æ,¬O§_=33
4) ·s²z³fÀɦC¼Æ¤Ó¦h«h§R°£,¤Ó¤Ö«h·s¼W,¦sÀÉ,Ãö³¬
5) §¹¦¨«á´«²Ä2­ÓÃöÁp¦r....¤@ª½¨ì8­ÓÀÉ¥þ³¡§¹¦¨,
6) ¼W¥[or§R°£¦C¼Æ,¤@©w­n¾ã¦C&«O«ù¤u§@ªí­ì®æ¦¡
7) ±M®×²z³f¤ºªº²z³f¦C¼Æ,±`·|¦]»Ý¨D¦Ó¼W¥[´î¤Ö,¦Ó·s²z³f³æ¸ê®Æ§¨¤ºªº8­ÓÀÉ,¥þ³¡³£­n¤@¨Ö§ó·s,
8) µ{¦¡­n¯à¥HMacro_2.xlsmªºAC:ADÄ檺ÃöÁp¨Ó¶}ÀÉ&¤ñ¹ï¦C¼Æ

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD