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

[µo°Ý] À°¦£¸ÑÄÀ³o­Ó¼Ò½k¤ñ¹ï½d¨ÒÀÉ

[µo°Ý] À°¦£¸ÑÄÀ³o­Ó¼Ò½k¤ñ¹ï½d¨ÒÀÉ

¥i¥HÀ°§Ú»¡©úªþÀɤ¤ªºµ{¦¡½Xªº²[·N¶Ü?«Ü¦n¥Î¡A¦ý¬Ý¤£À´?©Ò¥H¤£ª¾¸Ó«ç¼Ë­×§ï¦¨¦Û¤v»Ý­nªº¡C

¼Ò½k¤ñ¹ï.rar (11.43 KB)
Jess

¦n´ÎªºÀ³¥ÎÀÉ®×
·PÁ¤À¨É

TOP

ÁA¸Ñ¤F¡AÁÂÁ±zªºÀ°¦£!¤]ÁÂÁ¨ä¥L¦U¦ì¥ý¶iªºÀ°¦£«ü±Ð!
Jess

TOP

space­Ó¼Æ¤£¦P¡A¤j¤p¼g¤£¦P¡A¦³-¸ò¨S-
599-252  Washer»P599-252 Washer®t¤F¤@­Óspace
110334-1-ZA»P110334-1-Z-A®t¤F¤@­Ó-
40366109240 pIN­Y¤£¤À¤j¤p¼g«ç»ò§P©w¬O40366109240 PINÁÙ¬O40366109240  Pin
µ{¦¡ªºÅÞ¿è´N¥u¬O§âÃöÁä¦r¬O§_¦s¦b©ó·j´M¦r¦ê¤º
­Y·j´M¦r¦ê¤£¥]§t§¹¾ãÃöÁä¦r¡A·íµM¤ñ¹ï¤£¨ì
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ jesscc ©ó 2011-5-11 21:03 ½s¿è

Hsieh ¤j:

§Ú¤wªþ¤W¤u§@ÀɮסA¸ê®Æ®w¤¤»Ý­n­««ØÀɮתº³¡¤À¡A¤j·§³£¤w¸g¦³ÃФF¡C
¥Ø«e¦b¸ê®Æ¤ñ¹ï¤W¤´¦³´X­Ó¤j°ÝÃDµLªk¸Ñ¨M:

¨Ò¦p space,-,Ø,­^¤å¦r¥À¤j¤p¼g¤£¦P

¥u­n¤ñ¹ï®É¦³¥X²{¤W­±³o¥|ºØ±¡§Î¡A´N¤ñ¹ï¤£¨ì¤F¡C
¤§«e¦P¨Æ¤]´¿¼g¹L³o¼Ëªº¤ñ¹ï¸ê®Æµ{¦¡¡A¤j­P¤]¬O¸I¨ì³o¨Ç²~ÀV¡C

ªþÀÉ SPECforMRPtest.xls ªº Sheets("MRP")¤¤¦³¼Ð¥Ü¬õ¦rªº´N¬O¤ñ¹ï¤£¨ìªº¸ê®Æ¡C
Jess

TOP

¦^´_ 14# jesscc

°£«D¬O¥Î ºë·Ç¤ñ¹ï (100%ÃöÁä¦r¥h¤ñ¹ï)  §_«h ³q±`³£·|¦³§Ú©Ò»¡ªº±¡§Îµo¥Í
¤×¨ä¬O ¼Æ¾ÚªºªF¦è §ó®e©ö
¨Ò¦p WIN7 ªº·j´M¥\¯à ´N¦s¦b¦¹°ÝÃD
·j´M 10 ¨Ó»¡  ¸Ó·j´M½d³ò(¦p¦³ 1000µ§¸ê®Æªº¸Ü)  ·|±N  ·|±N 10 101~110 1000 ¥H«e ¸Ó·j´M½d³ò¤ºªºÀÉ®×(¦p¹ÏÀÉ) ªº®æ¦¡¦³ 10ªº¤]·|¦C¥X¨Ó  (¦p 100*56 ©Î 1010* 768)

TOP

¦]¬°¸ê®Æ®w¤ÓÃe¤j¡A§Ú¾ã²z¤@¨Ç¸û¨ã¥Nªí©Êªº¡A©ú¤Ñ¶Ç¤W¨Ó¡AÅý±z¬Ý¬Ý¡C¯uªº¦n·PÁ§A¡AÀ°§Ú¸Ñ¨M¤F¦n¦h°ÝÃD!
Jess

TOP

¦^´_ 18# jesscc

¸ê®Æ¤£¥¿½T¦³¥i¯à¬OSHEET2ªº¦r¦ê¤¤§t¦³2²Õ¥H¤WªºÃöÁä¦r
µ{¦¡·|»{©w²Ä¤@­Ó¤ñ¹ï¨ìªºÃöÁä¦r°µ§PÂ_
©Î³\§A­n¦bÃöÁä¦r¤¤ÂkÃþ¤U¥\¤Ò
¤W¶Ç§AªºÃöÁä¦r²M³æ¤Î¿ù»~ªº¸ê®Æ¬Ý¬Ý¤~¯à½T©w¥X¿ùªº­ì¦]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Ok¤F!
¥i¬O­è­è¥J²ÓÀˬd¤F¤@¤U¡Aµo²{¤ñ¹ï«á¶Ç¦^¨Óªº¸ê®Æ¡A¦³«Ü¦hµ§³£¤£¬O¥¿½Tªº¡A¯u¬O§Ö³Q³o­Ó¼Ò½k¤ñ¹ï·dºÆ¤F¡C
Jess

TOP

³o¬q´N¬O§Aªº¸ê®Æ½d³ò¹ï¶Ü?
For i = 1 To 32
  d(a & "") = Array(a.Offset(, i).Value)     ', a.Offset(, 2).Value, a.Offset(, 3).Value, a.Offset(, 4).Value)
Next i
³o¼Ë³æµ§¸ê®ÆÁÙ¬O¥u¦³4Äæ
§ï¦¨
Dim Ar(32)
For i = 0 To 31
  Ar(i) = a.Offset(, i).Value
Next i
d(a & "") =Ar
³o¼Ë´N¦³32Äæ¸ê®Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD