Sub test1()
Dim t
t = Timer
Application.ScreenUpdating = False
Call test2
Call test3
MsgBox Timer - t
End Sub
'下载数据
Sub test2()
Range("A1").CurrentRegion.Clear
With ActiveSheet.QueryTables.Add("url;http://zst.cjcp.com.cn/cjwssc_3x ... ian-ssc-0-3-30.html", [a1])
.WebFormatting = xlWebFormattingNone '导入所有格式
.WebTables = 3 '第3个表格(索引从0开始)
.Refresh False
End With
End Sub
'截取数据
Sub test3()
Dim A, B(1 To 30, 1 To 2), i, j
A = Range("A1").CurrentRegion
For i = 3 To 32
For j = 2 To 3
B(i - 2, j - 1) = A(i, j)
Next j
Next
Range("A1").CurrentRegion.Clear
[a1] = "期号": [b1] = "奖号"
[a2].Resize(UBound(B), UBound(B, 2)) = B
End Sub