|
本帖最后由 清华 于 2013-2-2 09:16 编辑
- Sub 记事本()
- Range("E1").Select
- Range(Selection, Selection.End(xlDown)).Select
- Dim mArea As Range, N&, i&, Str$
- If TypeName(Selection) = "Range" Then
- Str$ = ""
- For Each mArea In Selection.Areas
- For N = mArea.Row To mArea.Row + mArea.Rows.Count - 1
- For i = mArea.Column To mArea.Column + mArea.Columns.Count - 1
- Str = Str & Cells(N, i).Text
- If i < mArea.Column + mArea.Columns.Count - 1 Then Str = Str & vbTab
- Next i
- Str = Str & vbCrLf
- Next N
- Next mArea
- Open ThisWorkbook.Path & "\平台数据.txt" For Output As #1
- Print #1, Str
- Close #1
- End If
- End Sub
- 就是要保存的txt文件最下面没有空行
复制代码
- Sub 记事本()
- Range("E1").Select
- Range(Selection, Selection.End(xlDown)).Select
- Dim mArea As Range, N&, i&, Str$
- If TypeName(Selection) = "Range" Then
- Str$ = ""
- For Each mArea In Selection.Areas
- For N = mArea.Row To mArea.Row + mArea.Rows.Count - 1
- For i = mArea.Column To mArea.Column + mArea.Columns.Count - 1
- Str = Str & Cells(N, i).Text
- If i < mArea.Column + mArea.Columns.Count - 1 Then Str = Str & vbTab
- Next i
- Str = Str & vbCrLf
- Next N
- Next mArea
- Str = Left(Str, Len(Str) - 2)
- Open ThisWorkbook.Path & "\平台数据.txt" For Output As #1
- Print #1, Str
- Close #1
- End If
- End Sub
复制代码
|
|