"Query Refresh" Enable or Disable popup...how do i get rid of it!

[dark86]

please....

[anilsolipuram]

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://xyz.com/dd.jsp" , _
Destination:=Range("A2"))
.RefreshPeriod = 0
.
.
.
end with


make sure .refreshperiod=0, if not make 0 , save the file ,close the file and open it