Bot Failing because Quicklist not updating

[GoTheBunnies]

Hi guys - I run an Excel bot on Australian greys that I set to run with all my selections each morning.

Most days, Betfair haven't got all the markets up that my selections are running in when I set the bot - they put 1 or 2 up later in the day. Accordingly, my Quickpick list in Gruss has some missing markets as well. When the bot gets to those markets later in the day it falls over because it can't see them in the List.

How do I get the Quickpick list to update automatically when those markets become available later in the day?

Thanks

[MollyMoo]

What I did was to set up a couple of cells in Excel to hold the hours in 24 hour format I'd like to update the Quick Pick List.

On opening the workbook VBA sets an Application.OnTime event to the first of the times. The subroutine called by the OnTime event puts -3 in Cell Q2 (reload the QPL according to your settings) and resets the Application.OnTime event to the second time. On the next call the subroutine resets the Application.Ontime event back to the first time. That way the bot can run 24/7 if needed.

[xraymitch]

Nice one.