A macro to Download form data from webpage (Just learning about Excel at 61)

HectorIN2Excell

New Member
Joined
May 7, 2023
Messages
8
Office Version
  1. 2007
Platform
  1. Windows
I am trying to download webpage data from the link below and can do it to a certain standard but the data gets jumbled at times and isn't consistent
using procedures within excel.
Greyhound Bet | Greyhound Betting Web App from the Racing Post

So I would like to have my own macro that collects data from each race for 6 greyhounds.
with the data from each heading below in a table.

DateTrackDisTrpSplitBendsFinByWin/SecRemarksWnTmGngWghtSPGradeCalTm

The end product I would appreciate is to have the : The greyhound name, The data under each heading, Each race downloaded onto separate sheets, Race 1 on sheet1 upto last Race 12 on sheet 12. This is repeated for which ever greyhound track meeting I run at it on. (Tracks are like Romford, Crayford, Towcester, etc)
I am a oldie whois a newbie at this so I would really appreciate some of your wisdom and knowhow on this matter.

Thanks in advance
 
Yes I also would like to thank @nguyendang for your contribution and effort as with all the other contributors. Like I have said before I am in awe of you guys giving your time and effort and sharing your knowledge especially to guys like me who have started late. So I appreciate your help.
 
Upvote 0

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top