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

½Ð±Ð³s±µ¶W¹L4¬í¨S¦¨¥\,´N¸õ¥X­n¦p¦ó­×§ï?

½Ð±Ð³s±µ¶W¹L4¬í¨S¦¨¥\,´N¸õ¥X­n¦p¦ó­×§ï?

sub abc123()
    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"))
.WebTables = "1"
.Refresh BackgroundQuery:=False
End With
end sub

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD