Sub test()
Range("a1").CurrentRegion.ClearContents
With ActiveSheet.QueryTables.Add("url;http://zst.cjcp.com.cn/cjwssc_3x ... ian-ssc-0-3-30.html", [a1])
.WebFormatting = xlWebFormattingAll '导入所有格式
.WebTables = 3 '第3个表格(索引从0开始)
.Refresh False
End With
End Sub