- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- w7
- ³nÅ骩¥»
- 64
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-8-21
- ³Ì«áµn¿ý
- 2014-2-18
|
¹ïì§@ªÌ ¦Ü¤W³Ì°ªªº·P¼g
§Ú¤Þ¥Î쥻ªºcode¤p°µ×§ï¦p¤U
Sub Ex()
Dim i As Integer, s As Integer, k As Integer, A, ii, j
Dim co_id As String, isnew As String, season As String
Dim input_year As String
co_id = InputBox("½Ð¿é¤J ¤½¥q¥N¸¹")
If Not IsNumeric(Val(co_id)) Or Len(co_id) <> 4 Then Exit Sub '¤£¬O¥|¦ì¼Æªº¼Æ¦r
isnew = "2"
With CreateObject("InternetExplorer.Application")
.Visible = True
.Navigate "http://mops.twse.com.tw/mops/web/query6_1"
Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
With .document
For Each A In .getelementsbytagname("INPUT")
If A.Name = "co_id" Then A.Value = co_id
Next
For Each A In .getelementsbytagname("SELECT")
If A.Name = "isnew" Then
A.Value = True
If isnew = "2" Then
A.Focus
Application.Wait Now + #12:00:02 AM#
Application.SendKeys "{DOWN}"
Application.Wait Now + #12:00:02 AM#
Application.SendKeys "{ENTER}"
End If
End If
If A.Name = "year" And isnew = "2" Then A.Value = "101"
If A.Name = "month" And isnew = "2" Then A.Value = "05"
Next
For Each A In .getelementsbytagname("INPUT")
If Trim(A.Value) = "·j´M" And A.Name <> "rulesubmit" Then A.Click '«ö¤U[·j¯Á]Áä
Next
End With
Application.Wait Now + #12:00:10 AM# 'µ¥«Ýºô¶¤U¸ü¸ê®Æ
Set A = .document.getelementsbytagname("table")
On Error Resume Next '***¦³¨Çtable¨SRows¸ê®Æ·|²£¥Í¿ù»~ ¤£²z·|¥¦,µ{¦¡Ä~Äò¨«
With ActiveSheet
.Cells.Clear
'************************
' For ii = 0 To A.Length - 1 '¤£ª¾¹Dtable½d³ò¦b¦ó³B: ±q0¶}©l
'******************************
For ii = 11 To A.Length - 1 ''±q11¶}©l ¥Î Debug.Print ii §ä¥X©Òn¸ê®Æªºtable½d³ò
For i = 0 To A(ii).Rows.Length - 1 '¼g¤J¸ê®Æ
'Debug.Print ii ¥i§ä¥X©Òn¸ê®Æªº table ½d³ò
k = k + 1
For j = 0 To 5
Cells(k, j + 1) = A(ii).Rows(i).Cells(j).innerText
Next
Next
Next
.Range("C5").Cut Range("D5")
With .Range("B5:C5,D5:E5")
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Merge
End With
End With
'.Quit 'Ãö³¬ºô¶
End With
End Sub
§Ú¹J¨ì¤FIE cookieªº°ÝÃD,"¦~¥÷" ¨Ã¤£·|¸òµÛµ{¦¡½X¤¤©w¸qªº"101" ¦ÓÅܧó¨ì101
¥u¦³¬ö¿ý¤â°Ê®t¸ß¹Lªº¦~¥÷Ȧӧ@°Ê,¨Ò¦p
C:\Users\user\AppData\Local\Microsoft\Windows\Temporary Internet Files\Cookie:[email protected]/
¤º®e¦p¤U
"D102%"
¦pªG§Ú§ï¦¨D101% ,¦b¬d¸ß®É´N¥i¥HÅܦ¨101¦~,½Ð°ÝVBA¦³¨S¦³¸Ñ¨M¤è¦¡
§Ú´¿¸g¬O¹L¥ÎVBA ¿é¥XÀɮרì³o¸ê®Æ§¨¦n¹³¨S¦³¿ìªk
³oÓ¬O§Ú´ú¸Õªºµ{¦¡½X:
Sub XlsToTxT()
Dim MYstr As String, i As Integer '©w¸qÄÝ©Ê
Open "C:\Users\user\AppData\Local\Microsoft\Windows\Temporary Internet Files\63MX5O7N.txt" For Output As #1 '©w¸qOutput File¦ì¸m
Open "C:\63MX5O7N.txt" For Output As #1 '©w¸qOutput File¦ì¸m
For i = 1 To 10 '¥Ñ Row 1to10
MYstr = Cells(i, 1) '¿é¥Xªº¤º®e (©Î§AnªºªF¦è,¥i¦b¦¹¶}©l¦Û¤v©w¸q§a~)
Print #1, MYstr
Next i
Close #1
End Sub
newmops2
co_id%3D5489%7Cyear%3D102%7Cmonth%3D05%7C
mops.twse.com.tw/
1088
3112764800
30318700
2461393296
30318499
*
¸g¹L¿é¥X°Ê§@«á¨Ã¤£·|¦^¦s¬°cookieÀÉ®×
·|¯uªº¦s¦¨¤@ÓTXTÀÉ |
|