- ©«¤l
- 22
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 30
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- 7.0
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2014-4-6
- ³Ì«áµn¿ý
- 2024-3-31
|
¨ú±oºô¶ì©l½Xªº¸ê®Æ
½Ð°Ý¤@¤U¤p§Ì¥Ø«e·Q¨ú±ohttp://www.tdcc.com.tw/smWeb/QryStock.jsp³oºô¯¸ªºì©l¥N½X¤¤ªº<option >«áªº¥þ³¡¤é´Á
¥H¤U¬O¤p§Ì°Ñ¦Ò¸ê®Æ¼gªº¤@¬q
Dim web, url, webdata
url = "http://www.tdcc.com.tw/smWeb/QryStock.jsp"
Set web = CreateObject("Microsoft.XMLHTTP")
web.Open "get", url, False
web.send
webdata = Split(web.responseText, "<option >") <<<<<<<³o¸Ì¤@ÈÅã¥Ü¿ù»~
For j = 0 To UBound(webdata)
ThisWorkbook.Worksheets("¤u§@ªí1").Cells(j + 1, 1).Value = webdata(j)
Next
End Sub
½Ð°Ý¤p§Ì¸Ó¦p¦óקï¤~¯à¨ú±o©Ò¦³¤é´Á¸ê®Æ
Àµ½Ð«ü¾É·PÁ |
|