Cells.Clear Dim HTMLsourcecode, Url, TempArray() Set HTMLsourcecode = CreateObject("htmlfile") Url = "https://goodinfo.tw/StockInfo/StockList.asp?SHEET=現股當沖&MARKET_CAT=熱門排行&INDUSTRY_CAT=現股當沖張數" With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "POST", Url, False '.setRequestHeader "Content-Type", "application/x-www-form-urlencoded" '.setRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT" .setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" DoEvents .send HTMLsourcecode.body.innerhtml = convertraw(.ResponseBody)
Set Table = HTMLsourcecode.all.tags("table")(56).Rows ReDim TempArray(Table.Length - 1, Table(1).Cells.Length - 1) For i = 0 To Table.Length - 1 For j = 0 To Table(i).Cells.Length - 1 TempArray(i, j) = Table(i).Cells(j).innertext Next j Next i Range(Cells(1, 1), Cells(Table.Length, Table(1).Cells.Length)) = TempArray() End With End Sub