Hi,

I'm using Excel 2016 and I'm unable to use Get External Data from Web on the data ribbon as the page does not have the detail I require tabled. I'm using a Query in Get & Transform, From Other Source > The Web.

The issue I have, is I want to be able to refresh the query periodically how the query contains text which changes on a daily basis and therefore is unable to refresh.

So rather than tackle that head on, I've admitted defeat and I'm trying to code how to just create a new query for a certain web page and Table # so each time I can just delete the old Query and Connection and bring the same table in as a new query.
The Webpage I'm using is https://www.oddschecker.com/horse-ra...i-chase/winner however a file created a few weeks ago now doesn't work because of the change of text within the query.

Any advice on how to get this working?

I've recorded the routine and tried to remove the text which is ultimately an unknown variable but I get issues with the source

Thanks in advance