ªÑ²¼¸ê®Æ¶×¤J¡Aµ{¦¡°õ¦æ¦³°ÝÃD
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 41
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-1-2
- ³Ì«áµn¿ý
- 2016-12-28
|
ªÑ²¼¸ê®Æ¶×¤J¡Aµ{¦¡°õ¦æ¦³°ÝÃD
¥»©«³Ì«á¥Ñ GBKEE ©ó 2016-6-17 05:03 ½s¿è
¼Ò¥éª©¤j½s§ï¤@Óµ{¦¡
¦ý¶×¤J¦³®É·|°±¤î¤¤Â_¡A°±¤îªº¦ì¸m¤£¤@©w
§ÚÃhºÃ¬O°O¾ÐÅ餣¨¬¡A¸Ó¦p¦ó§ï©O¡H- Sub ¾ú¥vªÑ»ù§ó·s()
- Dim xTable As Object, k As Integer, c As Integer, r As Integer, rc As Integer, sn As Integer
- Dim url As String, i As Integer, E As Object
- With Sheets("Àç¹BÁZ®Ä")
- .UsedRange.Clear
- End With
- Sheets("Á`ªí").Select
- rc = Cells(Rows.Count, 1).End(xlUp).Row
- For i = 5 To rc
- sn = Cells(i, 1)
- url = "http://goodinfo.tw/StockInfo/StockBzPerformance.asp?STOCK_ID=" & sn & " &YEAR_PERIOD=10&RPT_CAT=M_YEAR"
- With CreateObject("InternetExplorer.application")
- .Visible = True
- .Navigate url
-
- Do While .Busy Or .readyState <> 4: DoEvents: Loop
- Set xTable = .Document.getElementsByTagName("TABLE")(11) '¸ê®Æ¦b³o
- With Sheets("Àç¹BÁZ®Ä")
- k = k + 1
- For r = 0 To xTable.Rows.Length - 1
- For c = 0 To xTable.Rows(r).Cells.Length - 1
- .Cells(k, c + 1) = xTable.Rows(r).Cells(c).innertext
- Next
- k = k + 1
- Next
- End With
- Set xTable = .Document.getElementsByTagName("TABLE")(13) '¸ê®Æ¦b³o
- With Sheets("Àç¹BÁZ®Ä")
- k = k + 1
- For r = 0 To xTable.Rows.Length - 1
- For c = 0 To xTable.Rows(r).Cells.Length - 1
- .Cells(k, c + 1) = xTable.Rows(r).Cells(c).innertext
- Next
- k = k + 1
- Next
- End With
- Set xTable = .Document.getElementsByTagName("TABLE")(19) '¸ê®Æ¦b³o
- With Sheets("Àç¹BÁZ®Ä")
- k = k + 1
- For r = 0 To 3
- For c = 0 To xTable.Rows(r).Cells.Length - 1
- .Cells(k, c + 1) = xTable.Rows(r).Cells(c).innertext
- Next
- k = k + 1
- Next
- End With
- .Quit
- End With
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 41
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-1-2
- ³Ì«áµn¿ý
- 2016-12-28
|
¦^´_ 4# c_c_lai
¼Ó¤W¤j¤j
§ÚªºªÑ²¼²M³æ¦³50Ó¡A¤À§å¸ê®Æ¸Ó¦p¦ó³B
§Úªºµ{¦¡¬O¦]¬°§Úªººô¸ô³t«×°ÝÃD¡H¦³®É®»¨ì²M³æ²Ä3¡B4Ó¡A¦³®É¥i®»¨ì²Ä20´XÓ |
|
|
|
|
|
|