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

[µo°Ý] ¦p¦óExcel §PÂ_ÃöÁä¦r,¦^©ß­È

[µo°Ý] ¦p¦óExcel §PÂ_ÃöÁä¦r,¦^©ß­È

¥»©«³Ì«á¥Ñ v03586 ©ó 2017-5-27 17:11 ½s¿è

§Ú¼g¤F¤@¤äµ{¦¡ , ¥\¯àºâ¬O§â­ì©l¸ê®Æ(database) ­«·s¾ã²z¤Î±Æ§Ç Åܦ¨²ßºDªº¼Ò¦¡
¦ý¦³¨Ç¥\¯à©|¥¼§¹¦¨, ·Q½Ð±Ð¦U¦ì¤j¤j­Ì¨ó§U

µ{¦¡°õ¦æ¤è¦¡ »Ý­n¦P®É¶}±Ò¡y­ì©l¸ê®Æ¡z+¡yTest Report¡z
µM«áÂI¿ïTest Report ªº¡y²£¥Í³øªí¡z§Y¥i

Module1 ¤¤ªº
Q1. NÄæ B/D ¥ý§PÂ_[³]©w]¸ê®Æªí ¯S®í¤Ï¦â¹Ï¸¹ ¦p²Å¦X,   ¦b [FMC]¸ê®Æªí LÄæ ¡yDevice¡z ¤Ï©³¦â ; MO»\³¹¹Ï(¶À©³)«h¬O¦b BÄæ¦ì ¤Ï©³¦â
¤Ï¦âªº½d¥»¦p[³]©w]¸ê®Æªí Title , ÂÅ©³¥Õ¦r¡B¬õ©³¥Õ¦r¡B¶À©³¦â
(Test Report)¦¹¥\¯à©|¥¼§¹¦¨ ¥Ø«e¬O¤â°Ê¶ñ¦â
Q2. NÄæ B/D²¤Æ  ¥u¯d ±q¥ªÃ䩹¥k«á²Ä¤@­Ó"-" ex: BDPSSS1230-0111-C ¡÷ 0111-C  (¥Ø«e¦¹¥\¯àOK)
       MÄæ Substrate²¤Æ ¥u¯d ±q¥ªÃ䩹¥k«á²Ä¤G­Ó"-" ex: 05-SS01-1005-VV ¡÷ 1005-VV  or 05-SS01-1007 ¡÷ 1007 (¦¹¥\¯àÁöµM¦³¼g ¦ý¤£OK)

Q3. §Ú³oµ{¦¡½X ¬O­n§PÂ_ , ¥u­n§PÂ_¡yFMC¡z¸ê®Æªí¤¤ "Device"Äæ¦ì ¦pªG»P"Flow"Äæ¦ì ¤@¼Ë´N¦X¨Ö"Flow"Àx¦s®æ
       (¥Ø«e³sAÄæ¦ì¤]·|¸òµÛ¦X¨Ö)  ÁÙ·|¸õ¥X³o­Óĵ§iµøµ¡ , ¤£ª¾¹D¦p¦ó¨ú®ø³o­Óµøµ¡
  1. For Each xRR In xArea
  2. '----±NFlow ¬Û¦P ¦X¨ÖÀx¦s®æ ¨Ãµe½u
  3.     If xRR & xRR(1, 34) <> xRR(0) & xRR(0, 34) Then Set xH = xRR
  4.     If xRR & xRR(1, 34) <> xRR(2) & xRR(2, 34) Then
  5.       Range(xH, xRR).Merge: Range(xH(1, 34), xRR(1, 34)).Merge    'Flow
  6.       Range(xH, xRR(1, 34)).Borders.Style = 1
  7.       For i = 7 To 10
  8.           Range(xH, xRR(1, 34)).Borders(i).Weight = xlMedium
  9.       Next i
  10.     End If
  11. Next
½Æ»s¥N½X
Q4. ¦A¨Ó³o­Ó¥\¯à¤]©|¥¼¼g¤J, ½Ð¦U¦ì¤j¤j¨ó§U , ´N¬O¦bµ{¦¡¦b©I¥s°Æµ{¦¡"call test"¤§«e
        ¦A¥h§PÂ_"­ì©l¸ê®Æ"Excel¤¤¡yH LOT¡z¸ê®Æªí , §Ú¦³¤Ï¶ÀªºÄæ¦ì
       ¨Ì·Ó¡y­ì©l¸ê®Æ¡zªºAÄæ¦ì¡yMONBR¡z»P¡yTest Report¡zªº"FMC"¸ê®Æªí¤¤ªºBÄæ¦ì¡yMONBR¡z¤ñ¹ï, ¤@¼Ëªº¸Ü°õ¦æ¤U°Ê§@
        ·í¡yStep¡zÄæ¦ì¬ODA*¡BCA*¡BRA*¡BSA*¡BSTA* ©Ò¹ïÀ³ªº¡yQty¡zÄæ¼Æ¦r¤j©ó0 , «h±N¡yEQPID¡zÄæ¦ìªº­È
       ±a¤Jµ{¦¡¡yTest Report¡z¤¤ªº¡yFMC¡z¸ê®Æªí¡yCA¡zÄæ¡B¡yDA¡zÄæ¡B¡yRA¡zÄæ¡B¡ySA(STA)¡zÄæ, ·|¥´*¥Nªí¥i¯à·|¦³CA01¡BCA02 ,©Ò¥Hµ{¦¡§PÂ_¥ÎCA*
       ¨ä¤¤SA*»PSTA* ³£©ñ¦b¡ySA(STA)¡zÄæ , ¦pªG¦³¦h­Ó¡yEQPID¡z­È, «h©ñ¤JÄæ¦ì¥Î¡y,¡z¹j¶}
      EX: DIC001,DIA002  , ¦pÄæ¦ì¡yMONBR¡z¦³¦h­Ó­«½Æ¡yEQPID¡z­È, ¥u»Ý­n¨ú¤@­Ó§Y¥i
        ¥Ø«eTest Report ¤]¬O¤â°Ê¶ñ¤J , ¤]´N¬O°õ¦æ§¹¦¨ªº¼Ë»ª, ½Ð¨D¦U¦ì¤j¤j¨ó§U¦p¤Wµ{¦¡¥\¯à

Test.rar (617.77 KB)

·Q½Ð±Ð¦U¦ì¤j¤j­Ì¦³¸Ñ¶Ü??

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD