I am pulling in data from the web using

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & webpitch _
, Destination:=Range("ha5"))

The data used to come in okay, but now it doesn't come in at all. I think it may be because the web site added pop up adds. Can I change something in my VBA code to avoid the pop-ups? Am I wrong, can this not be pop ups?

I found the problem, some reformatting of the page I was pulling from -- not pop-up adds. Sorry. Anyway, can pop-up adds cause problems when pulling directly into Excel?

"sg" wrote:

I am pulling in data from the web using

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & webpitch _
, Destination:=Range("ha5"))

The data used to come in okay, but now it doesn't come in at all. I think it may be because the web site added pop up adds. Can I change something in my VBA code to avoid the pop-ups? Am I wrong, can this not be pop ups?