Sub yahoo上櫃公司股價排行表()
Dim oxml As Object
Set oxml = CreateObject("winhttp.winhttprequest.5.1")
With oxml
.Open "GET", "https://tw.stock.yahoo.com/d/i/rank.php?t=pri&e=otc&n=30", 0
.send
Debug.Print .responsetext
End With
Set oxml = Nothing
End Sub
Sub yahoo上櫃公司股價排行表()
Dim oxml As Object
Set oxml = CreateObject("winhttp.winhttprequest.5.1")
With oxml
.Open "GET", "https://tw.stock.yahoo.com/d/i/rank.php?t=pri&e=otc&n=30", 0
.send
Debug.Print .responsetext
End With
Set oxml = Nothing
End Sub