Querytables.Add problem with destination Range

P

paloji

Joined
Oct 16, 2012
Messages
1
Reaction score
0
Hi everyone!!

First of all, sorry for my English, I´ll try to explain myself as best as I can ^^u

I am downloading a website on a sheet using querytables, but I don´t wont to dowload everything, the website has a lot of information I don´t need, just need some of the firsts rows, so I want it to stop around cell B9 (don´t need anything after it). I call this functions a lot of times in a loop, so it takes a lot of time doing innecesary work...

I´ve tried with:

Code: 
With Hoja2.QueryTables.Add(Connection:= _
    "URL;" + Hoja1.Cells(i, 10).Value, Destination:=Range("A1:B9"))
    .Refresh BackgroundQuery:=False
    End With

But it still loading the full page. Is it possible to stop it on B9?? or will always load everything??

Thank you very much in advance.
 
Back
Top