|
Sub Click()
Dim A, B(), i, s, p$
p = ThisWorkbook.Path & "\"
Range("a1").CurrentRegion.Sort key1:=[a1], order1:=xlAscending, _
key2:=[b1], order2:=xlAscending, _
key3:=[c1], order3:=xlAscending, _
Header:=xlNo
A = Range("a1").CurrentRegion
For i = 1 To UBound(A)
s = s + 1
ReDim Preserve B(1 To s)
B(s) = A(i, 2) & A(i, 3)
If i = UBound(A) Then
Call writeText(B, p, A(i, 1)): Erase B
ElseIf A(i, 1) <> A(i + 1, 1) Then
Call writeText(B, p, A(i, 1)): Erase B
End If
Next i
End Sub
Sub writeText(B, p, f)
Dim i
Open p & f & ".txt" For Output As #1
For i = 1 To UBound(B)
Print #1, B(i)
Next i
Close #1
End Sub
举例.rar
(27.29 KB, 下载次数: 6)
|
|