HTMLsourcecode.body.innerhtml = .responsetext Set Table = HTMLsourcecode.all.tags("table")(2).Rows
ReDim temp(Table.Length - 1, Table(10).Cells.Length - 1) For i = 0 To Table.Length - 1 For j = 0 To Table(i).Cells.Length - 1 temp(i, j) = Table(i).Cells(j).innertext Next j Next i temp(0, 0) = Replace(temp(0, 0), "法人持股走勢圖", "")
Erase temp Set GetXml = Nothing Set HTMLsourcecode = Nothing Application.ScreenUpdating = True Debug.Print Timer - ttt Exit Sub senderror: Debug.Print "error" End Sub