Private Sub CommandButton1_Click()
Dim i, j, Arr
Dim s() As String
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", "https://kl8.17500.cn/data/kl81000.txt", False
.Send
s = Split(.responseText, Chr(10))
End With
List = Array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
ReDim Arr(1 To UBound(s), 1 To 22)
For i = 0 To UBound(s) - 1
For j = 1 To 22
Arr(i + 1, j) = Split(s(i), " ")(List(j - 1))
Next j
Next i
With Cells(3, 1).Resize(UBound(s), 22)
' .ClearContents
.Value = Arr
End With
End Sub