Fetch data on multiple page web

[stoey]

hi guys,

i am trying to fetch data from a webpage which has multiple pages like 2000 pages which contains 25 rows and 16 columns in a table...can this be extracted in one sheet? I am using the code below but what I do is just simply duplicate the code and change the page range and sheet to where the data will be placed. like

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Notice that &start and Destination:=Range("a**")) changes...

Please Login or Register  to view this content.

I have like 200 of this repeated declarations except that the start and the range changes...can somebody help me simplify this procedures?

Thanks in advance...

[Leith Ross]

Hello stoey,

Try this out. This goes from 0 to 2000 in steps of 25:0,25,50, 75, etc. The destination ranges are at "A1", "A26", "A51", etc. You can go beyond 2000 if you need to.

Please Login or Register  to view this content.

[stoey]

Hello Leith,

First off is I would like to thank you on your response on this query. I tried the solution provided however I am receiving an error message Run-time error '424' Object required and is highlighting this part of the code:

Please Login or Register  to view this content.

any thoughts? thanks in advance again

[Leith Ross]

Hello stoey,

Oops! I forgot to prefix the QueryTablea.Add with the worksheet. It should be...

Please Login or Register  to view this content.

[stoey]

Hi Leith,

this code you have provided worked properly:

Please Login or Register  to view this content.

however, the output displays like seemingly "steps in a stair". I have changed 25 to 50 from this portion of the code

Please Login or Register  to view this content.

and they evetually displayed in a well proportioned manner like in an identical column but the thing is there are incomplete data that are being extracted. Though when using your original coding which has 25, it displays complete data but it just cannot display everything since the output is in a seemingly "steps in a stair". Sorry to be a pain here.

Thanks,

stoey