|
Sub 导入文本文件()
Dim Arr1, Arr2()
Application.ScreenUpdating = False
On Error Resume Next
FileName1 = Application.GetOpenFilename("文本 文件 (*.TXT),*.TXT")
Open FileName1 For Input As #1
Arr1 = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
Close #1
arr3 = Split(Arr1(0), " ")
ReDim Arr2(1 To UBound(Arr1) + 1, 1 To UBound(arr3) + 1)
For i = 0 To UBound(Arr1)
arr3 = Split(Arr1(i), " ")
For j = 0 To UBound(arr3)
Arr2(i + 1, j + 1) = arr3(j)
Next j
Next i
Sheets(1).Cells.ClearContents
Sheets(1).Range("a1").Resize(UBound(Arr2), UBound(Arr2, 2)) = Arr2
Application.ScreenUpdating = False
End Sub
引用上面的代马,不知是谁的了,存在问题:只能导入列数相同的数字,有8行,其中一行有5列,其余为7列,导出为8行5列有数字!那位能修改下?谢谢!
|
|