|
发表于 2014-4-19 09:55
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Application.DisplayAlerts = False '关闭报警
- Dim arr(), brr, string1 As String, i, c, n
- Open "C:\Users\EXCEL精英培训网\Desktop\复件待处理.txt" For Input As #1 '打开文本文件路径自己填
- string1 = StrConv(InputB(LOF(1), 1), vbUnicode)
- brr = Split(string1, Chr(10))
- For i = 0 To UBound(brr)
- For j = i + 1 To UBound(brr)
- If brr(j) Like "*ok*" And Not brr(j - 1) Like "*ok*" Then
- tx = brr(i)
- brr(i) = brr(j)
- brr(j) = tx
- End If
- Next
- Next
- Close #1
- Open "C:\Users\EXCEL精英培训网\Desktop\复件待处理.txt" For Output As #1 '打开文本文件路径自己填
- For Each c In brr
- Print #1, c
- Next
- Close #1
- Application.DisplayAlerts = True
- End Sub
复制代码 |
评分
-
查看全部评分
|