加入一个数组过渡吧,还是不太清楚怎么对分解字符的数组声明
Sub 导入()
Sheets("1").Select
Application.DisplayAlerts = True
Dim s() As String
Dim s2() As String
Dim arr(1 To 1, 1 To 100)
On Error Resume Next
Open ThisWorkbook.Path & "\文本\1.txt" For Input As #1
s = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
Close #1
For x = 0 To UBound(s)
s2 = Split(s(x), " ")
For y = 0 To UBound(s2)
arr(1, y + 1) = s2(y)
Next
ActiveSheet.Cells(x + 2, "B").Resize(, UBound(s2) + 1) = arr
Next
Application.DisplayAlerts = True
End Sub