|
- Sub tt()
- Dim str$, arr, i%, n%
- arr = Range("a1").CurrentRegion
- Open ThisWorkbook.Path & "/" & "abc.txt" For Output As 1
- For i = 1 To UBound(arr)
- str = ""
- For n = 1 To UBound(arr, 2)
- str = str & "," & arr(i, n)
- Next n
- str = i & str
- Print #1, str
- Next i
- Close #1
- Erase arr
- End Sub
复制代码
|
|