如题,想要访问某网址并上传经纬度数据,使用vba实现,正常访问时,使用如下指令:
With ActiveSheet.QueryTables.Add(Connection:= _
"URL; h t t p : / /eosweb.larc.nasa.gov/cgi-bin/sse/grid.cgi?&num=313136&lat=45&submit=Submit&hgt=100&veg=17&sitelev=&email=xxxxx@126.com&step=2&p=grid_id&lon=132" _
, Destination:=Range("$A$1"))。。。。。
"URL; h t t p : //eosweb.larc.nasa.gov/cgi-bin/sse/grid.cgi?&num=313136&lat=" & N1 & "&submit=Submit&hgt=100&veg=17&sitelev=&email=xxxxx@126.com&step=2&p=grid_id&lon=" & N2 _
"URL; h t t p : //eosweb.larc.nasa.gov/cgi-bin/sse/grid.cgi?&num=313136&lat=" & N1 & "&submit=Submit&hgt=100&veg=17&sitelev=&email=xxxxx@126.com&step=2&p=grid_id&lon=" & N2 _