G
Guest
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?
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?