实现了抓取指定网页某一层的数据:
Sub test1()
With ActiveSheet.QueryTables.Add(Connection:="URL;http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2016/13.html", Destination:=Range("$A$1"))
.Name = "13"
.FieldNames = True
.WebFormatting = xlWebFormattingNone
.WebTables = "5"
.Refresh BackgroundQuery:=False
End With
End Sub