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

[µo°Ý] ¹ïÀ³¤é´Á¶K½LÂI¸ê®Æ

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-7-20 23:35 ½s¿è

¦^´_ 22# PJChen

ÁÂÁÂn7822123«e½ú¡@¥ý¤U¸ü¨Ó¬ã¨s¤@¤U¡@:P

¦^¡@PJChen¤j¤j¡@(§C¯×) 250g¡@ªº¤é´Á§ï¤@¤U¡@´N¥i¥H¤F¡@¦]¬°¡@¤é´Á¹ï¤£¨ì©Ò¥H¨S¦³¶K¤W

¸U¹F®w¦sªí 2021.07¡@¤é´Á¡@»P¡@¦h«È¤á½LÂIªí¡@stock¡@¤é´Á¤j³¡¤À³£¤£¬Û¦P¡@ª½¦³¡@(­ì¨ý)250g¡@¡@1/5        1/6        1/7¡@¤é´Á¬O¥¿½Tªº

TOP

¦^´_ 22# PJChen

¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ¦³¨S¦³°ÝÃD  §Ú¬O¤À¶}¼g ¦Ó¥B°j°é¤]¤ñ¸û¦h  
´ú¸Õªº®É­Ô ¤é´Á ¥i¯à­n­×§ï¤@¤U ¦³¨ÇÀɮפé´Á¹ïÀ³¤£¨ì

n7822123«e½úªº¼gªk§ÚÁÙ­n¦A¬ã¨s  ºCºC§l¦¬ ^^"  
·PÁ  n7822123«e½ú ¤£µM·|¥d§ó¤[...¨þ¨þ..
0721.rar (937.48 KB)

TOP

¦^´_ 27# PJChen

¦]¬° ¤u§@ªíªºFormat(SP(2), "D") »P x ¹ï¤£¨ì  §ï¥Î¤å¦r®æ¦¡¤ñ¹ï¬Ý¬Ý
«Øij¥Î n7822123 «e½ú¼gªº·|¤ñ¸û¦n µ²ªG¬O¤@¼Ëªº ®Ä²v¸û°ª


Macro_1.rar (29.95 KB)

TOP

¦^´_ 35# PJChen
¦³ªÅ¸Õ¸Õ¬Ý§a §Ú¥u¬O§ï¤@¤U¦Ó¤w ¨S¦³­«¼g


javascript:;

Macro_1.rar (30.29 KB)

TOP

¦^´_ 37# PJChen
©êºp §ïªº®É­Ô¨S¬Ý²M·¡ ¦A¬Ý¬Ý¦³¨S¦³°ÝÃD·PÁÂ

javascript:;

Macro_1208.rar (30.11 KB)

TOP

¦^´_ 39# PJChen
¦b¬Ý¬Ý§a §Ú¤Ö§PÂ_¤@­Ó ÀɦW ¨þ¨þ.. >"<


javascript:;

Macro_1_1209.rar (30.03 KB)

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-12-13 12:53 ½s¿è

¦^´_ 41# PJChen

§Ú¸Õ ´Á¥½ ¥i¥H¶K¨ì ´Áªì  ¨S¦³°ÝÃD ©p¬O«ü ªº ½LÂI¸ê®Æ
Workbooks("¦h«È¤á½LÂIªí.xlsx").Sheets("stock") ¬O¬Æ»ò§@¥Î?
¥i§_¦b»¡©ú¤@¦¸ ²Ó¸`¨BÆJ ·PÁÂ

TOP

¦^´_ 43# PJChen

½Ð°Ý©pªºªí®æ®æ¦¡ ¥]§t¦h«È¤á½LÂIªí©M¨ä¥LÀÉ®×  ¬O§_³£¤£©T©w?

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-12-14 13:29 ½s¿è

¦^´_ 45# PJChen

¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý¦æ¤£¦æ ·PÁ  ¦ý °j°éÅܦh¤F¥Î¤F7­Ó°j°é..... ³t«×¤]·|ÅܺC¬Ý¬Ý¦³¨S¦³¤j¤j¥i¥HÀ°¦£^^"
    javascript:;

Macro_1_1214.rar (37.31 KB)

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-12-14 14:21 ½s¿è

¦^´_ 45# PJChen

³o¬O¥[¤J ´Á¥½©M½LÂI ¤@°_¤ñ¹ï ¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬ÝÁÙ¦³¨S¦³°ÝÃD ·PÁÂ

Macro_1_1214_.rar (40.71 KB)

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD