ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð±Ð¥æ©ö©Ò°£Åv°£®§ª½±µ§ì¤J¤u§@ªí?

½Ð±Ð¥æ©ö©Ò°£Åv°£®§ª½±µ§ì¤J¤u§@ªí?

http://www.twse.com.tw/zh/page/trading/exchange/TWT48U.html  
·Ó°£Åv¤é´Á¥Ñ¤p¨ì¤j±Æ§Ç

¤w¸Ñ¨M
Sub ¥æ©ö©Ò°£®§()
    Application.ScreenUpdating = False
    Sheets("Sheet1").Select
Cells.ClearContents
ddd = "URL;http://www.twse.com.tw/exchangeReport/TWT48U?response=html"
With ActiveSheet.QueryTables.Add(Connection:=ddd, Destination:=Range("$A$1"))
.Refresh BackgroundQuery:=False
End With
end sub

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD