Late morning, i take a snaphot of all the races in the quickpick list - the info which i then use closer to each race OFF - combined with later race data.
For months - i have been manually selecting each race in turn - waiting about 4 secs for the data to register into Excel - then keyboard selecting the next race .
I'm bored ! ha ha !
Setting the timer in BA to roll to the next race to = 240 mins just isnt the same as say an approximately 11 am snapshot
Is there a means to load the next race in the quick pick list - called from Excel ?
Assuming you are logging to Excel from A1 then Q2 is the cell where you need to put -1 which tells BA to move to the next market in the quick pick list