- ©«¤l
- 127
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 160
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-11-1
- ³Ì«áµn¿ý
- 2017-5-20
|
Sub Test()
Dim oIe, myData As DataObject, x
Set myData = New DataObject '»Ý¤Þ¥Î MS Form Object Library
With Sheets("°ÝÃD")
.Range(.[A4], .[F4].End(xlDown)).Copy
End With
myData.GetFromClipboard
Set oIe = CreateObject("internetExplorer.Application")
With oIe
'.Visible = False
.navigate "http://www.evepraisal.com"
Do While oIe.readystate <> 4: DoEvents: Loop
.document.getElementById("raw_textarea").innerText = myData.GetText '¶ñ¤J
.document.getElementById("result_submit").Click 'submit
Application.Wait Now + TimeValue("00:00:05") 'µ¥«Ý5¬í§¹¦¨
Set x = .document.getElementById("result_container")
¦pªG·Q¤À§O®»¨ú¬õ°é³B亖Ó 1 total sell value 2 total buy value 3 total volume ¤À§O¦s¤J L22 L23 L24 ®æ¤¤[/size]''
½Ð°Ýn«ç§ï©O? ·PÁÂ~
MsgBox x.All.tags("h4")(0).innerText
.Quit
End With
End Sub |
|