VBA Web scrape site and extract variable data

[ziggyfo]

Hi geniuses !
I have very little to offer in this regard and hoping somebody could help me if its not too big of an ask. I have been browsing for codes and tried various methods but have not had much success.

What im trying to achieve is scrape the below site for race results, however the results are variable and will change from day to day.

Each day the results will be updated as they happen, so below you will see some times that have not yet happened. Once they have happened they will populate 3 Places. Its worth noting that the color numbers are not text and appear to be images. I am looking for a code that can download all available races through out the day as and when its run to update with the new races.

Greyhound Racing Results for Today | Today's Results | Full Archive

Greyhound racing results for today. Get a fast and accurate horse racing results service for today's racing or search the Timeform greyhound racing results archive.

www.timeform.com

I guess the formatting can can be anything really, but if it could be extract almost as is, that would be phenomenal! I have made an example below for reference

The important part would be to be able to see the 1st, 2nd, 3rd winners so i can process the information further into a database.

Cheers

 

[ziggyfo]

No well rocks on my side as it is so it seems you did not follow my direction #2 - the bad reader classic trap ! - : where is located the code ? …​

And I forgot to say : for Windows only obviously …​

I followed your directions, I activated the additional object and pasted the code in the worksheet module.

Ill be honest, I am not sure what you mean by "beginner starter demonstration" but I have assumed its just your code. pardon me if I have that wrong.

I opened a new work sheet, opened a new module and paste your code as in in there. First I included the HTML object and then the followed the object error on the line mentioned earlier. Not sure what part I didn't follow?

 

[Marc L]

opened a new module and paste your code as in in there

This is your error as the code must be pasted not in any new module but in the worksheet module ‼​

One of the two ways : right click on the tab name then select code in the menu …​

​

As a starter demonstration, you could amend it if you want to add it in a general module​

you must add the worksheet reference each time it's necessary like for UsedRange as an example …​

 

[ziggyfo]

This is your error as the code must be pasted not in any new module but in the worksheet module ‼​

One of the two ways : right click on the tab name then select code in the menu …​

​

As a starter demonstration, you could amend it if you want to add it in a general module​

you must add the worksheet reference each time it's necessary like for UsedRange as an example …​

"you must add the worksheet reference each time it's necessary like for UsedRange as an example …"
Could you elaborate on this? I am not entirely sure what you mean with his, Do you mean I need to specify the cell reference where I want the data to go?

I have also tried the workbook but got the same error. See below, not sure if I'm doing something wrong, but here it is as I see it.

 

[Marc L]

​

Again your bad according to this picture ! The code as it is must be in the Sheet1 (Sheet1) worksheet module rather than in the workbook module !​

As I gave you a way to well paste the code in my previous post …​

 

[Marc L]

Do you mean I need to specify the cell reference where I want the data to go?

No as I never have stated about any cell reference ! …​

​

Hoping again you are under PC / Windows rather than on Mac …​

 

[ziggyfo]

​

Again your bad according to this picture ! The code as it is must be in the Sheet1 (Sheet1) worksheet module rather than in the workbook module !​

As I gave you a way to well paste the code in my previous post …​

Marc I do apologise, I have it working now. I clearly am a bad reader thanks for helping me through. Your code is exactly what I wanted.

 

[Marc L]

​

Solution always belongs to good readers ! Thanks for the Like !​