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

Â^¨ú¾ú¥vªÑ»ù

¦pªG»Ý­n¤@¦¸¤U¸ü¥þ³¡ªÑ²¼ªº¨C¤Ñ¦¨¥æ¸ê°T¡AEXCEL ¬O§_·|¶W¹L³B²z·¥­­¡C ¦³¤H¸Õ¹L¶Ü??

TOP

¦^´_ 1# white5168


    ¨S¿ìªk¤U¸ü

TOP

±N¤U¦C¤å¦r ¦s¦¨ ¤WÂdªÑ»ù¬d¸ß.iqy
¦b¶}±Ò´N¥i¥H¤F
WEB
1
http://www.otc.org.tw/ch/stock/aftertrading/daily_trading_info/result_st43.php
ajax=true&yy=["¤WÂdªÑ²¼ - ­ÓªÑ¤é¦¨¥æ¸ê°T","¿é¤J¬d¸ß¡u¦è¤¸¡v¦~¥÷"]&mm=["¤WÂdªÑ²¼ - ­ÓªÑ¤é¦¨¥æ¸ê°T","¿é¤J¬d¸ß¤ë¥÷"]&input_stock_code=["¤WÂdªÑ²¼ - ­ÓªÑ¤é¦¨¥æ¸ê°T","¿é¤JªÑ²¼¥N½X"]
Formatting=All
DisableDateRecognition=True

TOP

¦^´_ 10# white5168

«Ü©êºp¡A¥X²{¦p¤Uªº¿ù»~°T®§¡A½Ð±ÐÀ³¸Ó¦p¦ó¨Ó°µ­×¥¿???? ·PÁ±z

err.JPG
2012-11-28 16:00
Henry

TOP

¦^´_ 17# mannyhsu

diabo ¤j¤j,§A¦n! ÁÂÁ§A¨Ñ¤W¥«¾ú¥v¸ê®Æ¬d¸ß,±q¤¤¾Ç²ß³\¦h.
¥i§_½Ð敎¤WÂd¤U¸üCSV.file ­n¦p¦ó³B²z¡C

http://www.otc.org.tw/ch/stock/aftertrading/daily_trading_info/st43.php
¥H¤U¬O§Ú¥Ñ­ì©lºô­¶¸ê®ÆÀɤ¤¬d¸ß¥X¨Ó, ¸Õ¤F³\¤[µLªk¸Ñ¨M.  
function query()³o¬q¨ç¼Æ
var yy = document.getElementsByName("y_date1")[0].value;
var mm = document.getElementsByName("m_date1")[0].value;
var input_code = document.getElementsByName("input_stock_code")[0].value;
var param = 'ajax=true&yy='+yy+'&mm='+mm+'&input_stock_code='+input_code;

·PÁÂ!!!

TOP

¤v©ú¥Õ,  ¥Î·N¦b§PÂ_³Ì«á¤v§¹¦¨¤U¸üªº³Ì«á®É¶¡.  tks!

TOP

¦^´_ 19# white945

´L­«­ì§@ªÌ¡A¥u¶K¥X³¡¥÷µ{¦¡½X.

With Sheets("TWII")
        ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ = .Cells(Rows.Count, "A").End(xlUp).Row
        If ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then
            ¸ê®Æ®w³Ì«á¤@µ§¤é´Á = DateSerial(1999, 1, 1)
        Else
            ¸ê®Æ®w³Ì«á¤@µ§¤é´Á = .Cells(¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ, "A").Value
        End If
        ¸ê®Æ®w·s¸ê®Æ¼g¤J¦C¼Æ = ¸ê®Æ®w³Ì«á¤@µ§¸ê®Æ¦C¼Æ + 1
    End With

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-8-12 06:07 ½s¿è

¦^´_ 18# tsuneng

         Sub §ó·s¤j½L¸ê®Æ() ¤¤
            If ³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then   
         
           1 --> ªº¥Îªk

    ÁöµM¬Ý¤£¨ì§¹¾ãµ{¦¡½X
¤£¹L±q³o¤ù¬q¬Ý¨Ó¡A°õ¦æ³o­Ó§PÂ_¤§«eÀ³¸Ó·|¦³¬q­pºâ
³Ì«á¤@µ§¸ê®Æ¦C¼Æ=XXX¹Bºâ¦¡
¤~¨Ó§PÂ_"³Ì«á¤@µ§¸ê®Æ¦C¼Æ"³o­ÓÅܼƬO§_µ¥©ó1
³o¼Ë±ÀÂ_¤£ª¾¹ï§_¡A½Ð¦U¦ì«e½ú«ü¥¿

TOP

¦^´_ 16# diabo

¦]§Ú¬O·s¤â,¦³¤£©ú¥Õ³B½Ð±Ð  
½Ð  diabo ¤j¤j:  »¡©ú
        
         Sub §ó·s¤j½L¸ê®Æ() ¤¤
            If ³Ì«á¤@µ§¸ê®Æ¦C¼Æ = 1 Then   
         
           1 --> ªº¥Îªk

         ÁÂÁÂ!!

TOP

¦^´_ 17# diabo


    ½Ð°Ý¦pªG¬O¤W¥«¡B¤WÂdªº¾ú¥vªÑ»ù¸ê®Æ¬d¸ß, ¬O§_¤]¯à´£¨Ñ? ÁÂÁ¡C
manny

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD