|
发表于 2012-5-23 11:11
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim ar
- Dim i As Integer, j As Integer
- Dim fs, f, s
- Set fs = CreateObject("Scripting.FileSystemObject")
- Set f = fs.CreateTextFile(ThisWorkbook.Path & "\123-1.txt", True)
- ar = Range("a1").CurrentRegion
- For i = 1 To UBound(ar)
- s = ""
- For j = 1 To UBound(ar, 2)
- If ar(i, j) <> "" Then
- If s = "" Then
- s = ar(i, j)
- Else
- s = s & "," & ar(i, j)
- End If
- End If
- Next
- f.WriteLine (s)
- Next
- f.Close
- Set f = Nothing
- Set fs = Nothing
- End Sub
复制代码 |
|