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

[µo°Ý] VBA ½Æ»sdata°ÝÃD(¸óSheet)

¨Ï¥Îvba ½Æ»s°ÝÃD

¬O§_¥i¹ê²{¡A±qIPQC¼Æ­È¡A
­Y¦³¤­/¤»µ§¸ê®Æ³z¹L«ö¶s½Æ»s¨ìFQC¡]¦p¹Ï¤@¡^¡A§å¸¹-FQC +¸ê®Æ¼Æ­È
§å¸¹-FQC3
§å¸¹-FQC2
­Y¦³¥|µ§¸ê®Æ³z¹L«ö¶s½Æ»s¨ìFQC¡]¦p¹Ï¤@¡^¡A§å¸¹-FQC +¸ê®Æ¼Æ­È
§å¸¹-FQC3
§å¸¹-FQC1
­Y¦³¤Tµ§¸ê®Æ³z¹L«ö¶s½Æ»s¨ìFQC¡A§å¸¹-FQC +¸ê®Æ¼Æ­È
§å¸¹-FQC3
­Y¦³¤Gµ§¸ê®Æ³z¹L«ö¶s½Æ»s¨ìFQC¡A§å¸¹-FQC +¸ê®Æ¼Æ­È
§å¸¹-FQC2
­Y¦³¤@µ§¸ê®Æ³z¹L«ö¶s½Æ»s¨ìFQC¡A§å¸¹-FQC +¸ê®Æ¼Æ­È
§å¸¹-FQC1
³Â·Ð¦U¦ì¤j®vÀ°¦£¡I


¥¼©R¦W-1.jpg
2018-4-17 10:43

¥¼©R¦W-2.jpg
2018-4-17 10:44

VBA-Test.zip (425.36 KB)

TOP

[µo°Ý] VBA ½Æ»sdata°ÝÃD(¸óSheet)

VBA ½Æ»sdata°ÝÃD

1.§å¸¹§ì¨ú¨Ó·½
»¡©ú: ±qIPQC¤ºªº G2 Äæ¦ì±N§å¸¹½Æ»s¨ìA6/A7, ©T©w±N A6(§å¸¹-FQC3)/A7(§å¸¹-FQC2)
Lot No.jpg
2018-4-17 13:33

------------------------------------------------------------------------------------
2.¤é´Á§ì¨údata ¨Ó·½
»¡©ú: ª½±µ§ì¨úIPQC C1Äæ¦ì
Date.jpg
2018-4-17 13:32

------------------------------------------------------------------------------------
3.¾÷¥xÃ丹§ì¨ú¨Ó·½
»¡©ú: §ì¨úIPQC L4Äæ¦ì
Machine No.jpg
2018-4-17 13:35

------------------------------------------------------------------------------------
4.A1 ~ P data §ì¨ú¨Ó·½
»¡©ú:
­Y¼Æ­È¦³¤Tµ§®É
IPQC¤º«e¤Tµ§¼Æ¾Ú½Æ»s¨ìFQC3 ¼Æ­È¤º ¡]¦p¹Ï¤@¡^
§å¸¹-FQC3  «e¤Tµ§¼Æ­È
IPQC¤º«á¨âµ§¼Æ¾Ú½Æ»s¨ìFQC2 ¼Æ­È¤º ¡]¦p¹Ï¤@¡^
§å¸¹-FQC2  «á¨âµ§¼Æ­È
¹Ï¤@
A1-Data.jpg
2018-4-17 13:34

­Y¼Æ­È¦³¥|µ§®É
IPQC¤º«e¤Tµ§¼Æ¾Ú½Æ»s¨ìFQC3 ¼Æ­È¤º ¡]¦p¹Ï¤G¡^
§å¸¹-FQC3  «e¤Tµ§¼Æ­È
IPQC¤º«á¨âµ§¼Æ¾Ú½Æ»s¨ìFQC2 ¼Æ­È¤º ¡]¦p¹Ï¤G¡^
§å¸¹-FQC2  «á¨âµ§¼Æ­È
¹Ï¤G
A1-Data-4.jpg
2018-4-17 13:41

------------------------------------------------------------------------------------
5.M1 data §ì¨ú¨Ó·½
»¡©ú:
ª½±µ±NIPQC ¤ºF15/G15 ¼Æ­È½Æ»s¨ì FQC¤ºªºAL6/AM6¤º
M1-Data.jpg
2018-4-17 13:36


FQC ¸ê®Æ»Ý²Ö¿n¤U¥h, ¤£¥i²M°£

VBA-Test.zip (89.84 KB)

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

§A¦n,
°õ¦æµ{¦¡«áµo²{¦³¿ù»~, §Ú¦³¹Á¸Õ­×§ïµ{¦¡, ¦ý¬O¤´µMµLªk¨Ï¥Î, ¥i§_¨ó§UÀ°¦£¬Ý¤@¤U, ÁÂÁÂ
-----------------------------------------------------------------------------
­ì©lµ{¦¡
Set xE = Workbooks("FQC").Sheets("Input").[A65536].End(xlUp)(2)
§Ú¦³¹Á¸Õ­×§ïµ{¦¡¬°
Set xE = Workbooks("FQC").Sheets("Sheet1").[A65536].End(xlUp)(2)
-----------------------------------------------------------------------------
error.jpg
2018-4-18 08:15

error-1.jpg
2018-4-18 08:17

TOP

¥»©«³Ì«á¥Ñ dea172 ©ó 2018-4-18 14:34 ½s¿è

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

Dear ª©¥D,
·PÁ§ֳt¦^´_, ¦ý§Ú´ú¸Õ«á, ¤´¦³¥H¤U´XÂI°ÝÃD, ·Q¦A¦¸³Â·Ð§A, ÁÂÁÂ!
1.§Ú¦³§ó§ï¤¶­±«á, «ö¤UUpload ¥X²{Error message, ¬O§_»Ý­n­×§ï¤°»ò¦a¤è?
0418-error.jpg
2018-4-18 13:51

2.­YFQC Àɮ׫᭱¨â­Ó¸ê®Æ¥u­n©T©w§ì¨ú«e¨âµ§¸ê®Æ, ¦p¦ó­×§ïµ{¦¡?
FQC-2.jpg
2018-4-18 14:28

3.­YFQC Àɮ׸ê®Æ¥u­n©T©w§ì¨ú5µ§¸ê®Æ, ¦p¦ó­×§ïµ{¦¡?
FQC-5.jpg
2018-4-18 14:29

4.¬O§_¦³¾÷·|¥i¥H·s¼W­Y±qIPQC¶Ç¸ê®Æ¦ÜFQC¤º, §å¸¹­«½Æ·|µLªk¤W¶Ç

VBA ¸ê®Æ´ú¸Õ.zip (434.92 KB)

TOP

¥»©«³Ì«á¥Ñ dea172 ©ó 2018-4-19 09:19 ½s¿è

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

§A¦n,
ÁÂÁª©¥D©âªÅÀ°¦£, §Ú¦³¨Ï¥Î¥H¤Wµ{¦¡, ¤´µMµLªk¥¿±`°õ¦æ, §ÚÁÙ¬O·s¤â, ¤´¦³¥H¤U°ÝÃD, ³Â·Ð¤F

§ÚÁ`¦@¦³¤T­ÓÀÉ®×, ¤À§O¬°¥H¤U :
1.IPQC ÀÉ®× HÄæ¦ì¦³¤­­Ó¼Æ­È, FQC §ì¨ú¤­­Ó¼Æ­È (°Ñ閲ÀÉ®× CUP -1070)
5 PCS.jpg
2018-4-19 09:12


2.IPQC ÀÉ®× HÄæ¦ì¦³¤­­Ó¼Æ­È, FQC ¥u§ì¨ú«e¨â­Ó¼Æ­È(°Ñ閲ÀÉ®×L-15-3)
2 PCS.jpg
2018-4-19 09:14


2.IPQC ÀÉ®× P/MÄæ¦ì¦³¤­­Ó¼Æ­È, FQC ¦U§ì¨ú«e¨â­Ó¼Æ­È(°Ñ閲ÀÉ®×L-26P)
2-2 PCS.jpg
2018-4-19 09:15

CUP 1070.zip (56.28 KB)

L-15-3.zip (63.61 KB)

L-26P.zip (89.09 KB)

TOP

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

ª©¥D§A¦n,
¢°¡D¨C­ÓIPQC¬O§_¦U¹ïÀ³¤@­ÓFQC¡H¡@¥BÀɮצWºÙ«eºó¬Û¦P¡H
¡@¡@¨Ò¦p¡GL-26P-2018-IPQC¡@¹ïÀ³¡@L-26P-2018-FQC¡A¬Û¦P¬°"L-26P-2018"
->   ¨ä¹êÀɮ׬O¤@¹ï¤@ªº, ¤£·|¦@¥Î, ©Ò¥Hµ{¦¡¥i¥H¤À§O³]©w¤£·|¼vÅT

¢±¡DIPQCªº¢ÏÄ涵¥Ø¼Æ¶q¬O¡e©T©w¡fªº¡H¡@¥B¥²»PFQC¬Û¹ïÀ³¡H
->    IPQC A Äæ¦ì¦¡©T©wªº, ¥B»PFQC ¬Û¹ïÀ³

¢²¡D§ì¢´®æ©Î§ì¢±®æªº³W«h¬O¤°»ò¡H
¡@¡@©ÎªÌ¡A¥i§Q¥ÎIPQCªº¢ÙÄæ¡A§ì¢´µ§ªº¿é¤J¢´¡A§ì¢±µ§ªº¿é¤J¢±¡A´N¥Î³o¨Ó§PÂ_§ì´X®æ
->   ¨ä¹ê§Úªº·Qªk¬O, °w¹ï¤£¦P»Ý¨D³]©w¤£¦PÀÉ®×, ª½±µ±NÀɮ׸j¦º, ©È¨Ï¥ÎªÌ·|¦³key in ¿ù»~­·ÀI

TOP

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

ª©¥D§A¦n,
¤£¦n·N«ä, ­n¦A¦¸³Â·Ð
2.IPQC ÀÉ®× HÄæ¦ì¦³¤­­Ó¼Æ­È, FQC ¥u§ì¨ú«e¨â­Ó¼Æ­È(°Ñ閲ÀÉ®×L-15-3)
¹Ï¤ù¬Ý¬OMÄæ¦ì???
¬O§_¥Î"M"¨Ó§PÂ_¨ú2®æ???  ÁÙ¬O[³Ì«á¤@µ§]¨ú2®æ???
-> ³o个·|ÀHµÛ¸ê®Æ¦Ó¤£¦P, ³o¬O§_¥i¥H¨Ì»Ý¨D¦Ó¦Û¦æÅܧó?
EX: ­n"M"Äæ¦ì, ´N±qµ{¦¡¤¤§ó§ï¬°"M"Äæ¦ì
       ­n"H"Äæ¦ì, ´N±qµ{¦¡¤¤§ó§ï¬°"H"Äæ¦ì

2.IPQC ÀÉ®× P/MÄæ¦ì¦³¤­­Ó¼Æ­È, FQC ¦U§ì¨ú«e¨â­Ó¼Æ­È(°Ñ閲ÀÉ®×L-26P)
¬O§_¥Î"P"©Î"M"§PÂ_¨ú2®æ???  ©Î¬O[³Ì«á2µ§]¨ú2®æ???
->  ¹ï, ³o¤ñ¸û¯S§O, ³o个Àɮ׬°[³Ì«á2µ§]¨ú2®æ
µM«á, FQCÀɮצWºÙ¤£¬O©T©wªº, µLªk¼g¦º¦bµ{¦¡¸Ì(¤£µM¨C¦¸³£­n¤â§ï)???
->  FQCÀɮצWºÙ³o个§Ú¥i¥H¨Ì·Ó§ÚªºÀɮ׻ݨD¤â°Ê§ó§ïÅܧó

TOP

¦^´_ 14# Hsieh

ª©¥D§A¦n,
·PÁÂÀ°¦£, §Ú¦³¸Õ¹L,
1.¨S¦³­«½Æ§å¸¹½T»{,
2.¨C¶Ç¤@¦¸¸ê®Æ, ¨Ï¥ÎªÌÁٻݭn¶}±ÒIPQC ÀÉ®×, ¬O§_¦³§ó¤è«K¤è¦¡, ÁÂÁÂ!
µù: IPQC & FQC Àɮ׳£¬O©ñ¦P¤@¸ê®Æ§¨¤U

TOP

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

ª©¥D§A¦n,
´ú¸Õ«áOK, ¤£¦n·N«ä, ¦ý§ÚÁÙ¦³¤@­Ó°ÝÃD·Q½Ð±Ð, ¦A¦¸³Â·Ð¤F, ÁÂÁÂ
­Y·Q¸õ¹L IPQCÀɮתº P Äæ¦ì, ½Æ»s®É¤£±NPÄæ¦ì½Æ»s¨ìFQC¤º, ¬O§_¦³µ{¦¡¥i¨Ï¥Î?
¥¼©R¦W.jpg
2018-4-19 16:20

TOP

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

ª©¥D§A¦n,
´ú¸Õ«á, ¥i¥H¸õ¹L«ü©wÄæ¦ì, FQC M Äæ¦ì ¶]¨ì«á­±¤F, ªþ¤W¹Ï¤ù»Pµ{¦¡½X

2018-04-19_165308.jpg
2018-4-19 16:57

¥¼©R¦W.jpg
2018-4-19 16:58

Sample.zip (52.8 KB)

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD