website scrapiplping to get data from multiplepages of website

Helllo,

I am a very basic learner of vba coding of website scrapping, I want to get data from the website having multiple pages. I am using below code for that but getting data only of 1 page.

Code is as per below

Please Login or Register  to view this content.

above macro is recoded macro but I tried to change area "WebTables = """SitePH_grdSociety"""with page number but its extracting data only of one page

Thanks in advance

Can be done in one macro, but not with the method you're using.
You'll have to use winhttprequest5.1 or xmlhttp to get the response and what I can quickly see from the site, you'll have to send the request x times for x number of pages. I don't see the entire table content, but to be honest I haven't looked thoroughly.

The code below would get you the first page (like you have already), but would need adjustment from GET to POST and adjusted body content to get the other pages.

Please Login or Register  to view this content.

Unless someone writes you the entire scraper, my guess is that it's beyond your current capabilities to get this out.