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

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

¦^´_ 16# diabo

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

         ÁÂÁÂ!!

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

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

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

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD