|
Sub zq()
Dim url As String, tt As String
If Not IsEmpty(ActiveSheet.UsedRange) Then ActiveSheet.UsedRange.Clear
With CreateObject("msxml2.xmlhttp")
url = "http://jingzhi.funds.hexun.com/database/jzzs.aspx?fundcode=519962"
.Open "POST", url, False
.send
tt = .responsetext
tt = "<table class=""n_table m_table" & Split(Split(tt, "n_table m_table")(1), "</table>")(0) & "</table>"
With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
.SetText tt
.PutInClipboard
End With
[A1].Select: ActiveSheet.Paste
End With
MsgBox "获取完毕"
End Sub
|
|