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

[µo°Ý] VBA ¦C¦L¼ÐÅÒ¶K¯È

[µo°Ý] VBA ¦C¦L¼ÐÅÒ¶K¯È

¦U¦ì«e½ú¦n
¤p§Ì¦³¤@¦C¦L°ÝÃD
­n§â¤À­¶ªº¦WºÙ °µ¦¨¼ÐÅÒ¦C¦L¥X¨Ó
©ó³Ì«á¤@­Ó¤À­¶ "¼ÐÅÒ" ¦³½d¨Ò"
°µ¦nªº¦C¦L¼ÐÅÒ¦@¥Î8­Ó
¦ý­Y§Ú¶W¹L8­Ó¥H¤Wªº¤À­¶¤p§Ì´N¼g¤£¥X¨Ó
¨Cº¡8­Ó¤À­¶®É¡A´N¥ý¹wÄý¦C¦L¼ÐÅÒ¤§«á¦C¦L¡A«á­±¦A±q²Ä9¶}©l¡C
¨Ì¦¹Ãþ±À
¥»·Q­n¼g°j°é ¦ý§Ú¼g¨ì¥d¦í ·Q½Ð±Ð°ª¤â ¬O§_¦³§ó¦nªº¼gªk
¥t¥~ÁÙ·Q»¡¥ý§â¤À­¶¦WºÙ¤Î¬ÛÃö­n¦C¦Lªº¸ê®Æ ¥ý©ñ¦b¼ÐÅÒ­¶ ¦A¥ÎVBA¥h¼g¤@¼Ë¥d¦í!!
ªþ¤WÀÉ®× Áٽнç±Ð ÁÂÁÂ
¥X³f±½´y§Ç¸¹-210401-G¸¹¾÷.zip (213.44 KB)

·PÁ ¤ªºµ ¤j¤j ´£¿ô
¥X³f±½´y§Ç¸¹-210401-G¸¹¾÷.zip (213.57 KB)
­«·s¤W¶Çªþ¥ó
¨BÆJ ¦p¤U
1.Ū¨ú¨C­Ó¤À­¶ªº¦WºÙ 210401-G1~210401-G9
2.Ū¨ú¨C­Ó¤À­¶ªº¼Æ¶q¤Î ¸¹½XRange("J1"),Range("K4)
3.±N¨C­Ó¤À­¶ªº¦WºÙ ¤ÎŪ¨úªº¬ÛÃö¸ê°T Âà¨ì ¼ÐÅÒ¤À­¶
4.¼ÐÅÒ¤À­¶ ¦³¹w³]ªº8­Ó¼ÐÅÒ ¨Ã±N¬ÛÃö¸ê°T¦C¦L¥X¨Ó
³Æµù:
1..¼ÐÅÒ¤U­±ªºBarcode ¬OŪ¨ú¼ÐÅÒªº½c¸¹¨Ã§Q¥Î¦r«¬Âà´«¦¨±ø½X
2.¼ÐÅÒ­¶ªº¤º®e®æ¦¡³£¬O¹w³]¦nªº

°ÝÃD ¤À­¶¦³¤E­Ó ¦ý§Úªº¼ÐÅÒ¦³¤K­Ó  ­n¦p¦ó§â¥¦¦C¦L¥X¨Ó??
¦³¸ÕµÛ¼g°j°é  ·|¥d¦í ¦]¬° G1~G8 ¤§«á ·Q­n°µ¤@¦¸¹wÄý ¨Ã¦C¦L ¤§«á¦A­« G9~©¹«á©µ¦ù
¥Ø«eªºÀÉ®× §Úªº¤è¦¡  ¬O±NŪ¨ú¨ìªº¸ê®Æ ¥ý©ñ¦b¼ÐÅÒ­¶ªºI:KÄæ¦ì ¦A§Q¥Î¤½¦¡ §â¬ÛÃö¸ê®Æ §ì¨ì­n¦C¦Lªº¼ÐÅÒ¤W­±
¥H¤W ¨Ñ°Ñ¦Ò

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-10 15:54 ½s¿è

¦^´_ 2# fantersy

¦³ªÅÀ°§Ú¸Õ¸Õ¬Ý ¬O¤£¬O§A­nªºµ²ªG ·PÁÂ

¥X³f±½´y§Ç¸¹-210401-G¸¹¾÷0310.rar (277.67 KB)

TOP

¦^´_ 3# °a¤ªºµ
·PÁ ¤ªºµ¤j¤j
¹L¥Ø¤F¤@¤U¤º®e  °j°é¼g±o«Ü¦³§Þ¥©
Åý¤p§Ì¾Ç¨ì¤F¤£¤Ö  ¦A¦¸·PÁÂ

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-3-10 20:37 ½s¿è

¦^´_ 4# fantersy

§O³o¼Ë»¡ §Ú­Ì¤]¬O¤¬¬ÛÀ°§U §Ú¤]ÁÙ¦b¾Ç²ß¤¤¶¶«K½m²ß ³o¸Ì°ª¤â«Ü¦h ¦Ó¥B§Ú¼gªºÁÙ¬O·|¦³°ÝÃD ¦³¨Ç·|­«½Æ§PÂ_
¦]¬°¥u¯à©T©w¤@­¶8±i ¶W¹L´N·|¥X¿ù ¨ä¥L¥i¯àÁÙ¦³¨Sµo²{ªº°ÝÃD  §A¦b¨Ï¥Îªº®É­Ô­n¯d·N
¦Ó¥B¦³¨Ç¬O¥Î¿ý»sªº¤è¦¡ ¤£¬O¦Û¤v¼gªº ¥u¬O­×§ï¤@¤U¦Ó¤w  ÁÂÁ§Aµ¹§Ú¾÷·|½m²ß

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD