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

[µo°Ý] ¨Ï¥Î°}¦C¥N½X±a¤JªÑ²¼

[µo°Ý] ¨Ï¥Î°}¦C¥N½X±a¤JªÑ²¼

¦U¦ì«e½ú §Ú·Q­n§â°}¦C¥[¤J¸ê®Æ ,Åý9946¥i¥H±a¤J§Ú©Ò©w¸qªÑ²¼¦Cªí...
¦p¬õ¦â°Ï¶ô

9946-->¨ú¥N¦¨StockArr..

Dim StockArr As variable
StockArr = Array(9946,2330,2317,5522)'µ¥µ¥ªºªÑ²¼



Dim E As Object, i As Integer, ii As Integer, k As Integer
    Dim xadte As Date
    xadte = DateAdd("yyyy", -1, Date)  '¤é´Á(°_)¡G
    With CreateObject("InternetExplorer.Application")
        .Visible = True
        .Navigate "http://www.cnyes.com/twstock/intro/9946.htm"
        Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
        Set E = .document.getElementsByTAGName("TABLE")(4)
        ActiveSheet.UsedRange.Clear
        For i = 0 To E.Rows.Length - 1
            k = k + 1
            For ii = 0 To E.Rows(i).Cells.Length - 1
                Cells(k, ii + 1) = E.Rows(i).Cells(ii).INNERTEXT
            Next
        Next
        .Quit        'Ãö³¬ºô­¶
    End With
   
    Dim yadte As Date
    yadte = DateAdd("yyyy", -1, Date)  '¤é´Á(°_)¡G
    With CreateObject("InternetExplorer.Application")
        .Visible = True
        .Navigate "http://pchome.megatime.com.tw/stock/9946.html"
        Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
        Set E = .document.getElementsByTAGName("TABLE")(4)
        For i = 0 To E.Rows.Length - 1
            k = k + 1
            For ii = 0 To E.Rows(i).Cells.Length - 1
                Cells(k, ii + 1) = E.Rows(i).Cells(ii).INNERTEXT
            Next
        Next
        .Quit        'Ãö³¬ºô­¶
    End With
       
       
        Dim R As Range, Rng As Range
    For Each R In ActiveSheet.Range("A:A").SpecialCells(xlCellTypeConstants).Rows
    'ActiveSheet(§@¥Î¤u§@ªí) SpecialCells(xlCellTypeConstants "¥]§t±`¼ÆªºÀx¦s®æ")
         If Not IsError(Application.Match("¬ÛÃöÅvÃÒ", R, 0)) Then
            '¤u§@ªí¨ç¼ÆMatch ´M§ä¨ì0 ¶Ç¦^¼Æ¦r,§ä¤£¨ì0 ¶Ç¦^¿ù»~­È #N/A
            If Rng Is Nothing Then Set Rng = R Else Set Rng = Union(R, Rng)
            'Union ¤èªk ¶Ç¦^¨â­Ó©Î¦h­Ó½d³òªº¦X¨Ö½d³ò¡C
        End If
   Next
   If Not Rng Is Nothing Then Rng.EntireRow.Delete   '½d³ò¾ãÄæ§R°£

2014-12-28-Stock.rar (20.2 KB)

¦^´_ 3# GBKEE

GBKEE «e½ú§A¦n
§Ú·Q¦b¥[¤W¤@­Ó°}¦Cªí,·íÀx¦s®æ¦³§ä¨ìArrayªº²M³æ´N§â¸ÓROW§R°£..
Array = {º¦¶^,¥»¯q¤ñ,¦P·~,¥­§¡¥»¯q¤ñ,Á`¥«­È,§ë¸ê³ø¹S²v,¤µ¦~¥H¨Ó,³Ìªñ¤@¶g,³Ìªñ,¤@­Ó¤ë}
ªþ¤W¥t¤@­ÓÀÉ®×....

¦A³Â·Ð±z¤F...«D±`·PÁÂ...

Stock_20141229.rar (21.02 KB)

TOP

¦^´_ 5# GBKEE


    ·PÁÂGBKEE¤j¤j !! §Ú¤w¸g¥[¤Jµ{¦¡½X¤¤¤F ·PÁ±zªº¤j¤OÀ°¦£

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD