Retrieve some data from the Racing Post site:
the link below
[url removed, login to view]
displays data for 7 horses.
Given the race id and the race date, I want to retrieve every piece of data found on the 7 horse lines, from the NO column to the RPR column.
The data must be retrieved using Excel vba .
I want to retrieve the code.
Some columns include 2 pieces of info, for example the NO col contains 1and 6: 1 and 6 must be retrieved in distinct variables.
idem for the number which sometimes comes with the trainer or jockey name.
n.b. the 7 lines are those read after clicking on the AT-A-GLANCE CARD tab