Sub a() Dim Pa As String Dim Sav As String Dim S As String Dim i As Integer Dim j As Integer Dim arr() Pa = ThisWorkbook.Path Sav = "\abc.txt" arr = Range("a2:g" & Range("a1").End(xlDown).Row) Open Pa & Sav For Output As #1 '打开输出文件。 For i = 1 To UBound(arr) For j = 1 To UBound(arr, 2) S = S & arr(i, j) & "," Next j S = Left(S, Len(S) - 1) Print #1, S '打开输出文件。 S = "" Next i Close #1 End Sub 这是收集的(忘了谁帮我写的),我用的不多,也不是很明白。 [em04] |