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

[µo°Ý] ¨Ì·Ó³øªí§ë½u¶q»PUPH<¨C¤p®É²£¯à>­pºâ¶}¾÷¼Æ -- µo°Ý

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-11-28 22:37 ½s¿è

¤@¤Ñ¬ã¨s¸ê®Æ¡A¤@¤Ñ´M«ä¬[ºc¡A¤@¤Ñ¼gµ{¦¡¡A
¥»¤£·Q¼gªº¡]«áÄò°ÝÃDÀ³¤£¤Ö¡A®£µLªk¸ò©«¡^¡A¶È¯à°µ¨ì³o¸Ì¡A­n©ñªÅ¤F¡A
¨ä¥¦½Ð¦Û¦æ§V¤O¬Ý¬Ý¡ã¡ã

ªþÀɤU¸ü¡Gfunp.net¤W¤£¥h, ¥u¯à´£¨Ñ³o­Ó¤U¸ü§}
ON¶}¾÷¼Æ­pºâµ{¦¡.rar (489.09 KB)
http://www.funp.net/451843

DEVICE ©R¦W¤è¦¡¤EÅs¤Q¤K©ä¡A¶}´X±ø°ª³t¤½¸ô¤]¨S¥Î¡A
·Q¿ìªk±q·½ÀY¥h³W½d¤~¬O³Ì¦n¤èªk¡ã¡ã

TOP

¦^´_ 10# v03586


³øªíªºDATE TIME ¨ÃµL[¦~«×], ¥B¬°¡e¤å¦r®æ¦¡¡f¡A11/08  16:31¡A
Split("11/08  16:31", " ")(0) ¬O¨ú¥X 11/08,

­Y¬O¥HÀx¦s®æ«ü©w¤é´Á¡G
QDate = Format(Sheets("comply").[H13], "mm/dd")

­Y¬O©T©w¬°¹q¸£¤é´Áªº¡e¤µ¤Ñ¡f¡G
QDate = Format(Date, "mm/dd")

TOP

­×§ï¤@¤U¡e¦Û­q¨ç¼Æ¡f¡A
¬Ý¼Æ¾Ú¡ADEVICE ¦ü¥G³£¥H¡e«á­±¡fªº¸`ÂI¬°¥D¡A¤£¹L³oÁÙ¬O·§²¤ªºÀË´úªk¡AµLªk¦Ê¤À¦Ê¥¿½T¡G

Function Get_Layer(xStr$) As String
Dim i%, j&, N%, U, T, TT$, Ta$, Tb$
T = xStr
For Each U In Array("02G", "04G", "08G"):  T = Replace(T, U, Mid(U, 2)):  Next
¡@
T = Split(T, "-")
For j = UBound(T) To 0 Step -1
¡@¡@N = 0: Ta = "": Tb = ""
¡@¡@For i = 7 To 1 Step -1
¡@¡@¡@¡@TT = "-" & T(j)
¡@¡@¡@¡@If N <> 5 Then
¡@¡@¡@¡@¡@N = InStr(TT, 2 ^ i & "G")
¡@¡@¡@¡@¡@If N > 0 Then If Not IsNumeric(Mid(TT, N - 1, 1)) Then Ta = 2 ^ i & "G": Exit For
¡@¡@¡@¡@End If
¡@¡@Next i
¡@¡@If Ta = "" Then GoTo 101
¡@
¡@¡@N = N + Len(Ta)
¡@¡@For i = N To N + 2
¡@¡@¡@¡@Tb = Mid(TT, i, 1)
¡@¡@¡@¡@If Val(Mid(TT, i, 1)) Then Tb = Left(Val(Mid(TT, i)), 2): Exit For
¡@¡@¡@¡@Tb = ""
¡@¡@Next i
¡@¡@If Tb <> "" Then Get_Layer = Ta & "*" & Tb: Exit Function
101: Next j
End Function

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-11-30 10:27 ½s¿è

³øªí¡eCUSTNAME¡f²Å¦X¡e«ü©wÃöÁä¦r¡f¡A¤£¥[Á`¸Óµ§¼Æ¶q¡ã¡ã¡@

If InStr(RepArr(j, 2), "ENG") Or InStr(RepArr(j, 2), "CSP") Then GoTo 101
§ï¦¨¦p¤U¡G¡@
Dim x, XX
XX = Array("HQ-5F", "HQ5F", "HQ-2F", "HQ2F", "AT7F", "AT6F", "CSP", "ENG")
For x = 0 To UBound(XX)
¡@¡@If InStr(RepArr(j, 2), XX(x)) Then GoTo 101
Next

TOP

¦^´_ 17# v03586


ON¶}¾÷¼Æ­pºâµ{¦¡_v2.rar (489.14 KB)

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-12-2 10:23 ½s¿è

¦^´_ 19# v03586

¥[¤J[¥k¤è]¤Î[¤U¤è]¦X­p¡G
ON¶}¾÷¼Æ­pºâµ{¦¡_v3.rar (447.46 KB)

¦A¯S§O´£¿ô¡G
¡e¨ú¥Nªk¡f¡GLayer¤u§@ªíªº¹ï·Ó¸ê®Æ¥²¶·§¹¾ã¡A¥B¨Ì¡e¼Æ¦r¤j¡f¡e¦r¤¸¼Æ¦h¡fªÌ±Æ¦b³Ì¤W¤è¡A¤£µMÁÙ¬O°ÝÃD
¨Ò¦p¡G8GAA1¡D8GAA16
­Y¥u¦³8GAA1¡A¦Óº|¤F8GAA16¡A«h8GAA16·|³Qµø¬°8GAA1¦Ó¨ú¥N¤§¡A
©Î¡D8GAA1±Æ¦b8GAA16«e­±¡A«h8GAA16¤]·|¡eÀu¥ý¡f³Q8GAA1¨ú¥N¡A
¦P²z¡D8GAA1±Æ¦b128GAA1«e­±¡A«h128GAA1¤]·|¡eÀu¥ý¡f³Q8GAA1¨ú¥N¡I

¦hªá¨Ç®É¶¡¥h¤F¸Ñ¡e¨ú¥N¡f¶¶§Ç¤£¦P¡A©Ò³y¦¨ªºµ²ªG®t²§¡ã¡ã³o¥u¯à¾a¦Û¤v¥hÅÞ¿è±Àºt¡ã

TOP

¦^´_ 22# v03586


­Y KDRCK4MWGD-HAXHHH-HHQ ¬O¤@­Ó§¹¾ãªºDevice¦WºÙ¡A¨S°ÝÃD¡A
°£«DÁÙ¦³¥H¤U³o¨Ç¬Ûªñ¦WºÙ¡AÁÙ¬O­nª`·N¨äÀu¥ý¶¶§Ç¡G
KDRCK4MWGD-HAXHHH-HHQR  = 6G*4
HKDRCK4MWGD-HAXHHH-HHQ  =6G*1
BKDRCK4MWGD-HAXHHH-HHQ2 =6G*2

¥t¥~¡A³o¨Ç¯S§O«ü©w¦r¦ê¡A¨ä¢ÏÄ檺¢Õ¼Æ¡A¤£­n¿é¤J¢µ¡A§ï¬°¢¸¢¸¢¸¡A¤~·|±Æ¦b³Ì¤W¤è¡I

TOP

¦^´_ 24# v03586


¢°¡D¦P¤@¦WºÙ¤£¦P»sµ{¡H¦p¦ó¤ÀÃþ¡D¥[Á`¡A¤Î¦Cªí¡H
¢±¡D¦³¦WºÙ¡A«o¨S¦³»sµ{°Ñ¼Æ¥i¬Û°£¡A¼Æ¶q¡þ¡H¡þ21.5¡A«ç»òºâ¡H
¢²¡D¢Ó¢ÓÄ泡¥÷¦³»sµ{¡A³¡¥÷«hµL¡A¬Æ¦Ü¤£½T©w¨ú¥Xªº»sµ{¬O§_§¹¾ã¡H
¡@¡@¤£¬O¤p°ÝÃD¡A¤ñ¹ï¬Ý¬ÝÀɮפ¤¡e³øªí¡fªº¢ÕÄæ¤Î¢ÖÄæ¡G ON¶}¾÷¼Æ­pºâµ{¦¡_v4.rar (215.09 KB)

ªñ¦~©³¸û¦£¡A¥i¯à¸û¨S®É¶¡¸ò©«¡A¬Ý¬O¶WªO©Î¨ä¥L¤j¤j¥iÀ°¦£±µ¤â¡ã¡ã¡ã¡ã

TOP

¦^´_ 26# v03586


§ä¤£¨ì§¹¥þ¹ïµ¦, ¶XÁÙ¦³ªÅÀɭקï¤@¤U:
ON¶}¾÷¼Æ­pºâµ{¦¡_v4.rar (482.11 KB)

µ{¦¡¬OµL®Æ¡A¦ý³Ì²×ÁÙ¬O»Ý­n¡e¤H¤u¡f¥[®Æ³B²z¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD