- ©«¤l
- 109
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2017-11-19
- ³Ì«áµn¿ý
- 2023-7-5
|
¦^´_ 4# dea172
³oÀ³¸Ó¬O¦]¬°§A¨S¦³¦P®É§â³o¨âÓÀÉ®×¥´¶}¡A¦pªG§A·Q¥u¥´¶}IPQC´N°õ¦æµ{¦¡ªº¸Ü- Sub TEST()
- Dim Arr, Brr(1 To 2, 1 To 39), i&, j%, xE As Range
- Arr = [A4:J15]
- Brr(1, 1) = Split([G2], "-")(0) & "-FQC3"
- Brr(2, 1) = Split([G2], "-")(0) & "-FQC2"
- Brr(1, 2) = Year([C1]): Brr(2, 2) = Year([C1])
- Brr(1, 3) = [C1]: Brr(2, 3) = [C1]
- Brr(1, 4) = [L4]: Brr(2, 4) = [L4]
- For i = 0 To UBound(Arr) - 1
- If Arr(i + 1, 1) <> "M1" Then
- For j = 5 To 7: Brr(1, i * 3 + j) = Arr(i + 1, j + 1): Next j
- For j = 5 To 6: Brr(2, i * 3 + j) = Arr(i + 1, j + 4): Next j
- Else
- For j = 5 To 6: Brr(1, i * 3 + j) = Arr(i + 1, j + 1): Next j
- End If
- Next i
- Workbooks.Open Filename:="C:\Users\User\Downloads\VBA-Test\FQC.xls"
- Set xE = Workbooks("FQC").Sheets("input").[A65536].End(xlUp)(2)
- If xE.Row < 6 Then Set xE = xE(2)
- xE.Resize(2, 39) = Brr
- Workbooks("FQC").Close 1
- End Sub
½Æ»s¥N½X §âWorkbooks.Open Filename§ï¦¨§Aªº¸ô®|´N¦n |
|