- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# justintoolbox
¤]¥iÅã¥Ü¸ê®Æ¤é´Á- Option Explicit
- Sub Ex()
- Dim my_url, A, AR(), i As Integer, Msg As Integer
- Dim Sca_Date As String
- Sca_Date = "2015020" 'µ¹¿ù»~ªº¤é´Á
- 'Sca_Date = "20150105"
- my_url = "http://www.tdcc.com.tw/smWeb/QryStock.jsp"
-
- With CreateObject("InternetExplorer.Application")
- .Visible = True
- .Navigate my_url
- Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
- For Each A In .document.getelementsbytagname("SELECT")
- If A.Name = "SCA_DATE" Then
- ReDim AR(1 To A.Length)
- For i = 1 To A.Length '«ü"SELECT"ªº"OPTION"¼Æ¶q
- If Sca_Date = Trim(A(i - 1).innerHTML) Then Msg = i
- AR(i) = A(i - 1).innerHTML '¤é´Á¾É¤J°}¦C
- Next
- If Msg Then
- A(Msg - 1).Selected = True
- Else
- MsgBox " ¸ê®Æ¤é´Á ¨S¦³ " & Sca_Date & vbLf & Join(AR, vbTab)
- End If
- Exit For
- End If
- Next
- End With
- End Sub
½Æ»s¥N½X |
|