|
发表于 2014-12-31 10:31
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, rng As Range, i&, j%
- Set rng = Application.InputBox("请用鼠标选中数据", Type:=8)
- If rng.Count < 2 Then Exit Sub
- arr = rng
- Open ThisWorkbook.Path & "\1.txt" For Output As #1
- For i = 1 To UBound(arr)
- p = ""
- For j = 1 To UBound(arr, 2)
- p = p & "," & arr(i, j)
- Next
- Print #1, Mid(p, 2)
- Next
- Close #1
- End Sub
复制代码 |
|