½Ð°Ý¤U¸üÃÒ¥æ©Òɨé¨t²Îɨé¾lÃBªí
- ©«¤l
- 18
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN8
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-27
- ³Ì«áµn¿ý
- 2019-10-14
|
½Ð°Ý¤U¸üÃÒ¥æ©Òɨé¨t²Îɨé¾lÃBªí
http://www.twse.com.tw/ch/trading/SBL/TWT72U/TWT72U.php
½Ð°Ý¤Wz³oÓºô¶
¦b2016/02/17¥H«e..§Q¥Î¥H¤Uµ{¦¡½X³£¥i¥H±Nªí®æ¤U¸ü¦^¨Ó..
¦ý±q2016/02/18¶}©l..¤U¸ü¦^¨ÓªºÀɮ׳£¬O¨S¦³¤º®eªºªÅÀÉ®×..
mydate=105/02/17
xlpath="C:\"
With Workbooks.Open("http://www.twse.com.tw/ch/trading/SBL/TWT72U/TWT72U_PD.php?input_date=" & mydate & "&class_item=SLBNLB&type=csv")
.Application.DisplayAlerts = False
.SaveAs Filename:=xlpath & "TWT72U" & mydate & ".csv", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
.Close
End Wit
½Ð°Ý¥i¥H¦p¦óקï..¥H«K±Nªí®æ¤U¸ü¦^¨Ó..
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 18
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN8
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-27
- ³Ì«áµn¿ý
- 2019-10-14
|
½Ð°Ý³oÓºô¶ªºªí®æ
§Ú»Ýn¤U¸ücsv¦^¨Ó¦sÀÉ
¦pªGì¨Óªºµ{¦¡½X¤£¥i¦æ
¨º¸Ó¦p¦ó¼g
¬O§_¯à½Ð°ª¤âÌ´£¨ÑÂI·N¨£
©Î´£¥Ü¸Ó¦p¦óµÛ¤â
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
|
|
|
|
|
|
- ©«¤l
- 18
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN8
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-27
- ³Ì«áµn¿ý
- 2019-10-14
|
|
|
|
|
|
|