XP problem?

[mak]

email just sent

[GaryRussell]

The onTime function only runs once. After it has run it needs to be reset. I have updated my example.

In your spreadsheet changed the code in module1 to read as follows.

Code: Select all

Public Sub loadQuickPickList()
    triggerQuickPickListReload = True
    Application.OnTime TimeValue("06:00:00"), "loadQuickPickList"
End Sub


I am very sorry for the confusion this has caused. I should I have spotted this earlier.

[mak]

It is ok Gary (I wasn't able to check the macro)
I will try it & let you know
Thanks for your support

[mak]

Gary
I have to report that the new code is working fine
Just 1 question.Today morning that BF site was down I saw that the sheets kept trying to refresh, and the "fetching markets" progress was at ~14000 tries.I had to close the application because i didn't know if i could let it keep trying. So if sometime I am not able to close it is it ok?

* you got pm also

thanks

[mak]

[quote="mak"]Gary
I have to report that the new code is working fine
Just 1 question.Today morning that BF site was down I saw that the sheets kept trying to refresh, and the "fetching markets" progress was at ~14000 tries.I had to close the application because i didn't know if i could let it keep trying. So if sometime I am not able to close it is it ok?


when you can please tell me about it
* you got mail also

[GaryRussell]

Sorry, I missed this message. It is OK to leave it running. Because Betfair was unavailable the requests were instantly failing and therefore generating instant retries. In a future release I will change it so that it waits a second before trying again, but you can be sure the requests were not processed by Betfair and could not be charged for as excess requests.

[mak]

thanks Gary

[mak]

gary can you check your mail please?

[GaryRussell]

I have replied to your email nearly an hour ago. It probably got delayed. I will send you a PM which will be instant.