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

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

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

¦^´_ 14# PJChen
½Ð°Ý ¦³¤é´Á³¡¤ÀªºÀx¦s®æ ¦ì¸m¬O¤£¬O©T©wªº? ÁÙ¬O¨C¤@­Ó¬¡­¶Ã¯³£¤£¤@¼Ë? ¦C¦p ¸U¹F®w¦sªí ¦³¤é´Áªº³¡¤ÀÄæ¦ì®æ¦¡
¦]¬°§Ú¬Ý¨ä¥¦ªº¬¡­¶Ã¯ ®æ¦¡³£¬O¤£©T©wªº ¦³ªº¬O±qv7 ¶}©l ¦³ªº¤£¬O  ¬O¦]¬°³o¬O´ú¸ÕÀɮתºÃö«Y ÁÙ¬O­ì©lÀɮפ]¬O³o¼Ë?

TOP

¦^´_ 13# °a¤ªºµ
ºµ¤j¦n,
1) stock¤u§@ªí,¤£¯à§ï¬°Sheets(¼Æ¦r),¹ê»Ú¨Ï¥ÎÀɧt¦³¨ä¥L¤u§@ªí,³o¼Ë·|¥X¿ù
2) stockªº¨Ó·½ÀÉ,¥u­n«~¦W¶¶§Ç¤£¦P,´NµLªk¶K¤W¸ê®Æ,µ{¦¡´N¤¤Â_¤F
3) Workbooks("¦h«È¤á½LÂIªí.xlsx").Sheets("½LÂI")¤]¬O¬Û¦P±¡§Î,¤£¯à§ï¬°Sheets(¼Æ¦r)
4) ¤½¥qªº¦s©ñ°Ï,¦³«Ü¦hÀÉ,¤£¥u¬O³o´X­ÓÀÉ®×,¥B¦³Ãþ¦üÀɦW,©Ò¥H¥ÎDir(U & "*.xlsx")¤]·|¥X¿ù
     ¤W¦¸¸ß°Ý:ÀɦW¦]¬°³£«Üªø,·Q§ï¬°¶}ÀɮɥÎex: *¥Ã»·*,³o¼Ëªº¤èªk,¤£ª¾¥i§_?
5) ¤G­Óµ{¦¡³£»Ý­n¦³¤ñ¹ï«~¦Wªº¥\¯à¤~¦æ,¤£µM¤@¥¹«~¦W±Æ¦C¤£¦P,´N·|¥X¿ù¤F
Re¶K½LÂI¸ê®Æ0716.rar (944.92 KB)

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-7-16 05:02 ½s¿è

¦^´_ 11# PJChen
stock ¤u§@ªí §Ú¨S¦³§ï ¦]¬°§Ú³oª½¦³¤@ºØ®æ¦¡ ¦pªGÁÙ¦³ ½Ð¦A¦hµ¹´X­Ó  ¥u­n§â­n¶KªºÀɮ׳£©ñ¦b¦P¤@­Ó¸ê®Æ§X´N¥i¥H¤F¤£¥Î§ïÀɦW
¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ³o¼Ë¥i¤£¥i¥H µù¸Ñ¦³¥[¤F¤@¨Ç  ¦pªG¤£°÷²M·¡ ¥i¥H¦A¸ò§Ú»¡¬O­þ¤@¬q ·PÁÂ
¦]¬°³o¼gªk¤£¬O«Ü¦n ¬Ý°_¨Ó«Ü¶Ã ¦Ó¥B°j°é¤]¤Ó¦h¤F ¦pªGÀɮצhªº¸Ü·|«ÜºC ¬Ý¬Ý¦³¨S¦³¤j¤jÄ@·NÀ°¦£  §Ú¤]¥i¥H¶¶«K¾Ç²ß ^^"
·Pı§ÚªºÅ޿観°ÝÃD >"<
¶K½LÂI¸ê®Æ0716.rar (836.26 KB)

TOP

¦^´_ 10# °a¤ªºµ
ºµ¤j,
½ÐÀ°¦£¬ã¨s¤@¤U,
a) ¥ØªºÀɦ³¤GºØ©T©w®æ¦¡,¥Bkey-inªºÄæ¦ì½d³ò¬Û¦P,¥u¦³¦X¨ÖÀx¦s®æ¤À2¦C&3¦C
b) ¦Ó¨Ó·½ÀÉÁöµM½LÂI½d³ò¤£¦P,¦ý®æ¦¡¤j­P¬Û¦P,¥u¦³¦C¼Æªº¤£¦P,¤]¤À¬°¤GºØ®æ¦¡
1) ½LÂI°Ï¦b(½L®t)(¹w³]¤Ñ¼Æ)¤§¶¡
2) ½LÂI°Ï¦b(µ²¾l¦X­p)(½L®t)¤§¶¡
¦³¨S¦³¥i¯àµ{¦¡¥i¥H¥u§ïÀɦW,´N¥i¥H¾A¥Î©ó±q¨Ó·½¶K¨ì¥ØªºÀÉ?
(³Ì¦h´N¤À¦¨2­Óµ{¦¡,¤À§O¬O¶K¨ì½LÂI¡Bstock)
¦]¬°«È¤á·|¦³¼W¥[ªº¥i¯à©Ê,«~¦W¤]¬O,
§Æ±æ¯à°÷¦b¼W¥[«È¤á&«~¦W®É,¥u­n¦b¤u§@ªí©¹¤U¼W¥[,´N¥i¥H¨Ï¥Î,
¤£­n¦A¥h­×§ïµ{¦¡¡I
¥t¥~ÁÙ·Q½Ð°Ý,ÀɦW¦]¬°³£«Üªø,§Ú·Q§ï¬°¶}ÀɮɥÎex: *¥Ã»·*,³o¼Ëªº¤èªk,
§Ú¥uª¾¹D³oºØ¼gªk,¤£ª¾ÁÙ¦³¨ä¥L¤è¦¡¶Ü?
   Do While File <> ""
        With Workbooks.Open(Path & File)
------
   File = Dir
Loop
ÂAªá®w¦sªí.rar (148.25 KB)

TOP

¦^´_ 10# °a¤ªºµ

¦Aªþ¤W2­Ó´ú¸ÕÀÉ ¶K½LÂI¸ê®Æ_´ú¸Õ2.rar (330.44 KB)
µ{¦¡§Ú¦h´ú¸Õ¨Ç¦A¦^ÂÐ
½Ð°Ýµ{¦¡³Æµù,¯à§_¦A¸Ô²Ó¨Ç?

TOP

¦^´_ 9# PJChen

¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý  ¥i¥H¦A¦h´X­Ó­n¤ñ¹ïªºÀɮ׶Ü? ·PÁÂ
¦]¬°«~¦W §Ú¨S¦³§PÂ_

¶K½LÂI¸ê®Æ0715.rar (504.78 KB)

TOP

¦^´_ 8# °a¤ªºµ
ºµ¤j¦n,

´ú¸Õµ²ªG,Stockªº¤é´Á¨S¦³³sÄò®É,¶K¤Wªº½LÂI¸ê®Æ·|¤£¥¿½T,´ú¸Õµ²ªG¯d¦b¤u§@ªí¤¤,
§Ú¦³«Ü¦hÀÉ®×­n¥Î¨ì³o­Ó2­Óµ{¦¡,¥i§_À°¦£µù¸Ñµ{¦¡?
¶K½LÂI¸ê®Æ0710.rar (476.52 KB)

TOP

¦^´_ 7# PJChen
¦³ªÅÀ°§Ú¸Õ¸Õ¬Ý ·PÁÂ

¶K½LÂI¸ê®Æ0710.rar (493.98 KB)

TOP

¦^´_ 6# °a¤ªºµ
stock ¸ò ¸U¹F®w¦sªíªº´ú¸ÕÀÉ,¤é´Á³£¬O´ú¸Õªº,©Ò¥H§ï¤@¤U¥i¥H´ú¸Õ´N¦n¤F ¶K½LÂI¸ê®Æ0710.rar (470.04 KB)
----------¸U¹F®w¦sªí ½LÂI¸ê®Æ
(§C¯×)U8:AF8,¹ïÀ³stock BH7:CF7
(­ì¨ý)U11:AF11,¹ïÀ³stock BH10:CF10
¦³¬Û¦P¤é´Áªº½LÂI¼Æ,´N¶K¨ìstock¦P¬Û¤é´Áªº½LÂI®æ¤º

----------»e¸Á­Ü ½LÂI¸ê®Æ
V7:AK7,V9:AK9,V11:AK11¦P«~¦W&¦P¤é´Á¹ïÀ³
¦h«È¤á½LÂIªí.sh(½LÂI)BH6:CF6,BH8:CF8,BH10:CF10

TOP

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

¦^´_ 5# PJChen

stock ¸ò ¸U¹F®w¦sªí 2021.07 ¤é´Á¹ï¤£¨ì  ¦n¹³©Ç©Çªº ©p¦A½T»{¤@¤U

stock ª½¦³ 7/7  ¦Ó ¸U¹F®w¦sªí ¬O7/6~7/11 ÁÙ¬O ¥u­n 7/7 ¸¹?  ¤£¤Ó©ú¥Õ ¥i¥H»¡²M·¡¤@ÂI¶Ü ·PÁ ^^"

TOP

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