Help me loop for endpoint for extracting the data from web

[yogananda.muthaiah]

Hi folks,

Need quick help from your side on looping the endpoint of the URL (events_attended_id) needs starting from 1 to 100000

In below case : events_attended_id=238

http://inter.viewcentral.com/Events/...ttended_id=238

Please Login or Register  to view this content.

[yogananda.muthaiah]

Please some one add the loop for >>>>> "events_attended_id=XXXX"

[yogananda.muthaiah]

Attached which is almost completed but loop is left out

[yogananda.muthaiah]

Can some one quickly fix the loop part.

[AB33]

You will get an error if the id does not exist.
You need to adjust this line

1 To 238

change the 238 to what ever figure you want

Please Login or Register  to view this content.

[yogananda.muthaiah]

Thanks AB33,

the error is showing because the tables values should be going one below the other. It's now printing on the same line.

Can you please modify the code to print the tables in the sheet row-wise according to the loop created.

[AB33]

No, if I did not move the rows and columns count above the loop, the loop will always return row 1.
The code errors on this line

For Each Tr In .Rows

which is nothing to do with the loop -I.
Is it because the table you are trying to extract does not have rows?
You can use your old code: all you need is just include my loop (Only 2 lines) in to your code.

For i = 1 To 238

next

[yogananda.muthaiah]

Hi AB33,

I tried but couldn't able to do as you said,

I want the header in 2nd row and from 3rd row details of loop (i) from 1 to 238 needed.