照搬老师的开头·· Option Explicit Private Sub CommandButton1_Click()
Dim IE As Object 'Dim IE As MSXML2.XMLHTTP Dim arr() As String Dim brr() As String Dim i As Long Dim k As Long Dim t1 As Integer Dim t2 As Integer Dim t3 As Integer Dim t4 As Integer Cells.Clear 'Set IE = New MSXML2.XMLHTTP Set IE = CreateObject("Msxml2.XMLHTTP") IE.Open "GET","http://video.shishicai.cn/Assist/BonusVideo.aspx?lt=4&isTransfer=ok", False IE.send "" 后面的不会了··· End Sub |