|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 fzxba 于 2023-2-6 16:39 编辑
- Sub test0()
- Dim ar, i As Integer
- Dim p As String, pt As String, f As String
- Dim s As String, t As String
- s = String(3, "*")
- p = ThisWorkbook.Path & "\"
- pt = p & "Result\"
- If Dir(pt, vbDirectory) = "" Then MkDir pt
- f = Dir(p & "*.txt")
- While Len(f)
- Open p & f For Input As #1
- ar = Split(StrConv(InputB(LOF(1), #1), vbUnicode), s)
- Close #1
- For i = 0 To UBound(ar)
- t = Trim(ar(i))
- If Len(Replace(t, vbCrLf, "")) Then
- Open pt & Replace(f, ".txt", Split(t, ":")(0) & ".txt") For Output As #2
- Print #2, s & t
- Close #2
- End If
- Next
- f = Dir
- Wend
复制代码 |
评分
-
1
查看全部评分
-
|