|
楼主 |
发表于 2017-6-30 11:15
|
显示全部楼层
苏子龙 发表于 2017-6-30 10:40
fileToOpen = Application.GetOpenFilename("文本(*.txt), *.txt", , "读取数据")
If fileToOpen = Fa ...
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
就是大侠之前这段代码,怎么修改下能弹出个自己能选择文件夹路径的框然后读取这个文件夹中的文件。
|
|