Import data from website into excel using VBA

[kipulbiu]

Hello,

I was wondering if anyone could help

For each horse meeting ( Réunion 1, 2, 3 etc. ) I would like a VBA macro to be able to import into exce all the following information from this free website.

http://www.geny.com/reunions-courses-pmu?date=2018-08-29

Column A: Date
Column B: race time ( Hours )
Column C: Meeting ( Reunion R1, R2,etc.)
Column D: Horse course name ( Deauville, Vincennes etc.)
Column E: Race number ( 1ere, 2eme etc..)
Column F: Horse 1 from ( Le pronostic located under the runners list table called: Partants )
Column G: Horse 2 from ( Le pronostic located under the runners list table called: Partants )
Column H: Horse 3 from ( Le pronostic located under the runners list table called: Partants )
Column I: Horse 4 from ( Le pronostic located under the runners list table called: Partants )
Column J: Horse 5 from ( Le pronostic located under the runners list table called: Partants )


The 2 following links might be of use:

http://www.geny.com/reunions-courses-pmu/_d2018-08-29?#reunion1
http://www.geny.com/partants-pmu/2018-08-29-deauville-pmu-prix-du-bocage-normand_c998685

Example for the first 3 races in the meeting one today:

Date	Hours	Reu	Race course	Race NB	H1	H2	H3	H4	H5	B1	B2
29/08/2018	13:47	R1	Deauville	1ere	1	16	14	6	4
29/08/2018	14:20	R1	Deauville	2me	8	9	6	3	1

<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>

I hope the above is clear and that you are in a position to help

Thank you in advance

Bruno