Quick pick list

[waynethebrayn]

Hi Gary,

I see that the Virtual Racing is now added to the quick pick list - is there an associated value for the Q2 cell in Excel to automatically update this quick pick list?

While I'm here (and been meaning to ask for a while) is it possible to have an addtional value of 0.5 mins in the Markets > Auto Select Markets > At specific time before off function (and also include this in the Excel > Log multiple sheets quick link function)?

I'm also tempted to look at the Betdaq application, although I've never used their site, could you send me a link for the excel program? Are there any major differences in the way the Betdaq application runs?

Thanks in advance.

Wayne

[GaryRussell]

-3.19 can be used to load the virtual racing.

I'll see what I can do about 0.5 minutes before off, should be a simple addition.

I'll PM you the Betdaq link.

[waynethebrayn]

Gary,

Thanks for your replies.

Sorry to be a pain but I have another query regarding the quick pick list, not sure if it is a bug or if I'm doing something wrong:

I use the Excel > Log multiple sheets quick link sheet to load up separate tabs for horse racing & greyhounds, and then use a bit of VBA code to refresh the quick pick lists for each tab every 3 hours. I then just let my computer run (for days on end sometimes). However there have been occasions where the refresh seems not to have happened on one or more of the tabs.

I think it may be because a previous refresh has cleared the quick pick list completely, leaving no market selected. The reason I think this is because it happens most on Australian greyhounds (which sometimes are added late) and Irish horse racing (which sometimes has gaps of a few days between meetings, particularly with the bad weather lately).

I don't seem to get the problem where future events are added a day or more in advance (e.g UK & RSA racing).

Thanks in advance for your help.

[mak]

waynethebrayn hi
if it is not problem for you can you post the vba code please?

I am trying to do exactly the same thing but I am stuck (see previous post)

Hope you don't mind
thanks

[GaryRussell]

I'm not sure it's because the quick pick list is empty. I did notice recently that the quick pick list has sometimes not loaded when I first open the program and I think it's possibly down to an API error which isn't been handled. I will improve the error handling code in the next release and you can see if the problem still occurs. The next release will be out in the next few days.

[mak]

Gary
yesterday after a format of my laptop I installed only BA & the aplications it needs.I also made one workbook for every market I use (previous they were all in the same workbook)

So today mornig your code worked fine & all my sheets were updated

My problem is with horse markets that they updated during the same day
so now I need a sample that will check if the paricular market is updated

see here http://www.gruss-software.co.uk/forum/v ... php?t=4434

* Also woking fine with firefox...

[waynethebrayn]

Gary - thanks for the reply, I'll continue to monitor.

mak - this is my code:

Public Sub refreshQuickPick()
ThisWorkbook.Worksheets("UK HORSES").Range("Q2").Value = -3.1
ThisWorkbook.Worksheets("IRE HORSES").Range("Q2").Value = -3.3
ThisWorkbook.Worksheets("US HORSES").Range("Q2").Value = -3.5
ThisWorkbook.Worksheets("AUS HORSES").Range("Q2").Value = -3.7
ThisWorkbook.Worksheets("NZ HORSES").Range("Q2").Value = -3.9
ThisWorkbook.Worksheets("RSA HORSES").Range("Q2").Value = -3.11
ThisWorkbook.Worksheets("UK DOGS").Range("Q2").Value = -3.12
ThisWorkbook.Worksheets("AUS DOGS").Range("Q2").Value = -3.13
ThisWorkbook.Worksheets("VIRTUAL").Range("Q2").Value = -3.19

Application.OnTime Now() + TimeValue("03:00:00"), "refreshQuickPick"

ThisWorkbook.Worksheets("STATUS").Range("B4").Value = Format(Now, "dd/mm/yyyy hh:mm:ss")
End Sub

It basically populates the required values to refresh each quick pick list, then runs every 3 hours. The last bit returns the date & time that the code was last run into a different Excel sheet.

I am far from being a VBA expert and learnt the above from a combination of web research, Gary and the other good people on this forum. I'll have a look at your other post and reply to your query there, if I can.

[mak]

I will try this code also later at home, but I will need to populate the -1 trigger also in oredr to move to next market (I can't use any of the prefix in BA interface)

Thanks waynethebrayn

[waynethebrayn]

Gary,

Not sure if this is a related problem but when earlier this evening BA/excel seemed to hang, apparently because I wasn't around to acknowledge the error message box that appears because markets didn't load (presumably none were available yet).

Can the message box be turned off or ignored without user intervention?

Cheers,

Wayne

[GaryRussell]

I'll look into it.

[GaryRussell]

Gary,

Not sure if this is a related problem but when earlier this evening BA/excel seemed to hang, apparently because I wasn't around to acknowledge the error message box that appears because markets didn't load (presumably none were available yet).

Can the message box be turned off or ignored without user intervention?

Cheers,

Wayne

I think it may have been the virtual racing markets that caused this issue if they were not yet available. I will release an update later which does not display a message box.