How to scrape through VBA

I’m trying to scrape the following webpage https://crownbet.com.au/sports/soccer
And yet it loads https://crownbet.com.au and does not copy paste anything into Excel

Please Login or Register  to view this content.

Also is there a way to make the data stop when no next button?

Use below code to export source code to text file. You can then study what's been returned from web service.

Please Login or Register  to view this content.

It turns out that table is filled by function from JSON string.

You can find meat of data after "app.module.zendesk.zendeskController"

You can then use string manipulation to extract JSON string. Then use either RegExp, VBA-JSON or ScriptControl to parse JSON and output to Excel.

Hi CK76,

It appears I just get a error of Run-time error '76' path not found when tryimng to post this code into excel

Please Login or Register  to view this content.

Please Login or Register  to view this content.

As noted, change path if you don't have "C:\Test\" Folder.