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

½Ð°Ý¤U¸üÃÒ¥æ©Ò­É¨é¨t²Î­É¨é¾lÃBªí

½Ð°Ý¤U¸üÃÒ¥æ©Ò­É¨é¨t²Î­É¨é¾lÃBªí

http://www.twse.com.tw/ch/trading/SBL/TWT72U/TWT72U.php
½Ð°Ý¤W­z³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¸ü¦^¨Ó..
ÁÂÁÂ

½Ð°Ý³o­Óºô­¶ªºªí®æ
§Ú»Ý­n¤U¸ücsv¦^¨Ó¦sÀÉ
¦pªG­ì¨Óªºµ{¦¡½X¤£¥i¦æ
¨º¸Ó¦p¦ó¼g
¬O§_¯à½Ð°ª¤â­Ì´£¨ÑÂI·N¨£
©Î´£¥Ü¸Ó¦p¦óµÛ¤â
ÁÂÁÂ

TOP

¦^´_ 2# go2hk

http://club.excelhome.net/forum.php?mod=viewthread&tid=1159783&page=1&authorid=218917

§â³oùجݧ¹¦Û¤v¸Õ¸Õ¬Ý´N·|ª¾¹D

¦pªG¤W­±ªºµ{¦¡¬O§A¦Û¤v¼gªº

§A¥u­n¬Ý¤Wªºªº¶W³sµ²¾Ç¤@¤U´Nª¾¹D

¤U¸üªºPOST¤è¦¡¦³¨Ç«K°Ê

TOP

·PÁ¦^ÂÐ ¬ã¨s¤¤

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD