|
本帖最后由 苏子龙 于 2017-6-30 14:34 编辑
Sub test2() '选择多个txt文件
Dim arr, rw%, i%
Dim FiletoOpen, atxt
On Error Resume Next
Sheet1.UsedRange.ClearContents
FiletoOpen = Application.GetOpenFilename(filefilter:="Text Files(*.txt),*.txt", Title:="请选择文件", MultiSelect:=True)
If Not IsArray(FiletoOpen) Then
MsgBox "你没有选择文件", vbOKOnly, "提示": Exit Sub
Else
For Each atxt In FiletoOpen
rw = rw + 1
Open atxt 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
Next
End If
End Sub
按ctrl多选 |
|