|
发表于 2017-6-12 15:57
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, rw%, i%, flm$
- On Error Resume Next
- Sheet1.UsedRange.ClearContents
- flm = Dir(ThisWorkbook.Path & "/*.txt")
- Do While flm <> ""
- rw = rw + 1
- Open ThisWorkbook.Path & "/" & flm For Input As #1
- arr = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
- Close #1
- With Sheet1
- .Cells(rw, 1) = Split(arr(1), ",")(0)
- .Cells(rw, 2) = Split(arr(6), ",")(2)
- .Cells(rw, 3) = Split(arr(6), ",")(6)
- End With
- flm = Dir
- Loop
- End Sub
复制代码 自己照着改改吧 |
|