Quickpick refresh

[philuk]

Hi there

Just a short question...

I use the quickpick refresh sheet , but it refreshes only at midnight every day.

Is it possible to make it refresh in the mornings?

Reason for this is that the virtual racing ends at 07:57 in the morning and then starts again at 09:03 am.

I tried changing the code to 08:00 instead of 00:00:00 , but did not work.

Just wanted to know if I am doing soething wrong.

Thanx
Philip

[mak]

are you changing both module & worksheet timers?I have the same copy & it is working fine in the morning..

[philuk]

Hi there

When i view the code for sheet1 then i only change the following :

Private Sub Workbook_Open()
Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
End Sub


Is there anything i need to change in this one :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
Application.EnableEvents = False
If triggerQuickPickListReload Then
triggerQuickPickListReload = False
Range("Q2").Value = -3
triggerFirstMarketSelect = True
Else
If triggerFirstMarketSelect Then
triggerFirstMarketSelect = False
Range("Q2").Value = -5
End If
End If
Application.EnableEvents = True
End If
End Sub


Thanx

[philuk]

Ok , thanx for that.

Just found that I did not change the module.

That was still on 00:00:00

Thanx again for that

Philip

[philuk]

Hi there

Is there a way to let the quickpick list refresh at midnight and at 8:00 in the morning.

got it to refresh at 8:00 in morning , but just noticed I need it to do it at midnight also.

Thanx again

[GaryRussell]

Change the code in module1 to the following.

Code: Select all

Public Sub loadQuickPickList()
    triggerQuickPickListReload = True
    If Hour(Now) = 0 Then
        Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
    Else
        Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
    End If
End Sub


[philuk]

Thanx for that

I copied and replaced it all over to module one

Just want to know about the general code :

Private Sub Workbook_Open()
Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
End Sub


Must I leave it like that.

Thanx

[GaryRussell]

The Workbook_Open code only runs once when you first open the workbook. If you open it after 8am then it will miss the midnight refresh. If you open it before then it doesn't need changing.

For completeness you can change it as follows.

Code: Select all

Private Sub Workbook_Open()
   If hour(now)>=8 then
      Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
   else
      Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
   End If
End Sub

[xraymitch]

I have preferences set to only load today's market yet when I fired up BA after 8am this morning (no sheets loaded) the Quickpick list was populated with the virtual racing for the 18th and the 19th, rather than just the 18th which I was expecting.

Cheers

PS Thanks for the code really helpful

[GaryRussell]

That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.

[Yorkie]

I've mentioned this here http://gruss-software.co.uk/forum/viewtopic.php?t=4648

The correct date is in the quick pick list as soon as they appear, I assume this isn't what ba uses to order them. Could this info be used by BA to order them correctly from the start?

Yorkie

[philuk]

The Workbook_Open code only runs once when you first open the workbook. If you open it after 8am then it will miss the midnight refresh. If you open it before then it doesn't need changing.

For completeness you can change it as follows.

Code: Select all

Private Sub Workbook_Open()
   If hour(now)>=8 then
      Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
   else
      Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
   End If
End Sub

Thanx for this Gary

You have been an excellent help in this.

Appreciate it loads !!!

Philip

[xraymitch]

That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.

Thanks for the feedback Gary, I must admit to becoming more and more disenchanted with the service that Betfair offers it's consumers.

[GaryRussell]

That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.

Thanks for the feedback Gary, I must admit to becoming more and more disenchanted with the service that Betfair offers it's consumers.

I have uploaded official version 1.1.0.65e and Beta version 1.1.0.66d to fix this problem. It overrides the date with the date from the market name.

[xraymitch]

Gary you really are a STAR

Many thanks

PS Have you noticed the posts are 1 hour ahead ? ie it's 7:34 at the time of writing this postscript