Autoload next days events?

[cooldad]

I like to run a bet bot for multiple consecutive days, without human intervention. In order for this to work, BA should automatically select markets for a new day as soon as the new day arrives (let´s say at midnight).

In other words, BA should auto load the quick pick list at midnight (or as soon as the races are available).

I know I can automatically reboot the PC, and autostart BA and the trigger spreadsheet, but this leaves me with other problems, like auto logon to BA, selecting the trigger spreadsheet from BA etc.

Is there a way to achieve this?

Thanks!

[GaryRussell]

Entering -3 in cell Q2 will reload the quick pick list so you can use VBA to populate this cell at the appropriate time.

[cooldad]

Thanks, Gary, I knew you would've built in something like this!

I am using the Application.onTime function to enter the value in Q2, and it works perfectly.

For others that are interested in doing the same, here's the VBA code

In the code for ThisWorkbook, add the following:

Private Sub Workbook_Open()

Application.OnTime TimeValue("12:00:00"), "ReloadQuickPickList"

End Sub

When the spreadsheet opens, this will set a timer so that at 12:00:00, the macro "ReloadQuickPickList" will be executed.

Then anywhere in your modules, add the following macro:

Sub ReloadQuickPickList()

Application.OnTime TimeValue ("12:00:00"), "ReloadQuickPickList"
Workbooks("YourWorkbook.xls").Worksheets("BetAssist").Range("Q2") = -3

End Sub

This will set a new timer (to be executed the next day), and then it enters the value -3 in cell Q2 which will result in reloading of the quick pick list in Betting Assistant.