jsleee

±z¦n
½Ð°Ý¥H¤U³o­Ó´Á³f¥æ©ö¸ê°Tªººô­¶¡A­Y­n³z¹Lµ{¦¡½X¨Ó§ì¨ú¤£¦P¤é´Áªº¸ê®Æ¡A¸Ó¦p¦ó³B²z¡H
¦A³Â·Ð¥ý¶i­Ì«üÂI¡AÁÂÁÂ
http://www.taifex.com.tw/chinese/3/7_12_1.asp

t8899

¦^´_  t8899


¦Û¤v½m²ß¬Ý¬Ý
joey0415 µoªí©ó 2017-6-3 20:50

·PÁ«ü¾É

joey0415

¦^´_ 24# t8899
http://www.tse.com.tw/fund/BFI82U?response=html&dayDate=20170601&type=day

¦Û¤v½m²ß¬Ý¬Ý

t8899

¦^´_  prin.huang

ºô§}¦³¤F

¦Û¤v½m²ß
joey0415 µoªí©ó 2017-5-24 21:38

½Ð±Ð¤U­±³o­Óºô§}³o»ò§ì?
http://www.tse.com.tw/zh/page/trading/fund/BFI82U.html

jsleee

¦^´_ 21# prin.huang


    ¤F¸Ñ
    ·PÁ§A

JS

t8899

ºô§}¦³¤F

¦Û¤v½m²ß¬Ý¬Ý
joey0415 µoªí©ó 2017-5-24 21:35

½Ð±Ð¤@¤U¡A¦r«¬¸ò¤j¤p¦p¦ó±±¨î??

prin.huang

¦^´_ 19# jsleee

§Ú§ä¨ìªº¤èªk¬Oºô­¶¤W¦³download htmlºô­¶ªº«ö¶s¡A
«ö¤U¥h·s¶}ªººô­¶ºô§}´N¬O¤F¡A
µw¬O¬Ý¤F¥b¤Ñºô­¶µ{¦¡½X¡A¤~µo²{­ì¨Ó«ö¤@¤U´N¦³µ²ªG¤F

f3202

¦^´_ 5# joey0415


  ÁÂÁ  J¤j ¤w¸Ñ¨M

jsleee

¦^´_ 17# joey0415


    ±z¦n¡A§Ú¤]«Ü¦n©_¡A¦p¦ó¨ú±o¸Óºô§}¡H
    ¯à§_½Ð joey¥ý¶i«üÂI°g¬z
    ·PÁÂ

JS

t8899

ºô§}¦³¤F

¦Û¤v½m²ß¬Ý¬Ý
joey0415 µoªí©ó 2017-5-24 21:35

Sub Macro1()
Cells.Clear
ddd = "URL;http://www.twse.com.tw/fund/T86?response=html&date=" & Format(Date, "yyyyMMDD") & "&selectType=ALL"
With ActiveSheet.QueryTables.Add(Connection:=ddd, Destination:=Range("$A$1"))
.Refresh BackgroundQuery:=False
End With
End Sub