- ©«¤l
- 4
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-1-18
- ³Ì«áµn¿ý
- 2023-10-5
|
§Úªºµ{¦¡¡A¤@¦¸·|§ì¨ú¤@¦~¤U¨ÓªºTDCC ¸ê®Æ
¤£¾å±o³o¦¸§ïª©«á¡A§Úªºµ{¦¡¨ºÃä¹ïÀ³¤£¨ì¡A
Sub GoTDCC1yr()
'
' GoTDCC1yr Macro
'
Dim TWYear, CEYear As String
For m = 1 To 51
Dim WinHttp As Object, DOM As Object, Table As Object
Dim url As String, Title() As String, Stockid As String, weekDate As String
Dim i As Integer, j As Integer
TWYear = Sheets("¤T¤jªk¤H").Cells(m, "O") '¥Á°ê¦~¤é´Á
CEYear = Sheets("¤T¤jªk¤H").Cells(m, "P") '¦è¤¸¦~¤é´Á
Sheets(TWYear).Activate
StartTDCC:
Stock = Worksheets("¤T¤jªk¤H").Range("M1").Value 'ªÑ²¼¥N½X
weekDate = Sheets("¤T¤jªk¤H").Cells(m, "P") '¦è¤¸¦~¤é´Á tdcc ¥Î¦è¤¸¦~¤ë¤é
url = "https://www.tdcc.com.tw/portal/zh/smWeb/qryStock" ' §ï³o¼Ë¬O§_¥¿½T¡H
' url = "https://www.tdcc.com.tw/smWeb/QryStockAjax.do" 쥻url
Set WinHttp = CreateObject("winhttp.winhttprequest.5.1")
Set DOM = CreateObject("htmlfile")
With WinHttp '³o¸Ì¤£ª¾¦p¦ó§ï¹ïÀ³³o¦¸ªº§ïª©
.Open "POST", url, False
.setrequestheader "Content-Type", "application/x-www-form-urlencoded"
.send "scaDate=" & weekDate & "&clkStockNo=" & Stock & "&REQ_OPR=SELECT"
If .Status = 200 Then
DOM.body.innerHTML = .responsetext
End If
End With
Set Table = DOM.getElementsByTagName("table")
i = 1
For Each tr In Table(6).Rows ' ÁÙ¬O¦^¶Ç¸ê®Æn§ï¡H
j = 1
For Each td In tr.Cells
Sheets(TWYear).Cells(i, j) = td.innerText
j = j + 1
Next
i = i + 1
Next
i = 2
For Each tr In Table(7).Rows
j = 1
For Each td In tr.Cells
Sheets(TWYear).Cells(i, j) = td.innerText
j = j + 1
Next
i = i + 1
Next
Set Table = Nothing
Set DOM = Nothing
Set WinHttp = Nothing
Next
End Sub |
|