Gruss Forum • View topic

by **mak** » Mon Jan 25, 2010 7:08 am

In my second laptop (which I mainly would like to use only for BA) with windows XP I experience I strange problem

I have a xl sheet that populate at q2 the -1 value (Select the next market in the Quick Pick List) every 2 minute for example

BA works ok with that, but if I open firefox for example BA just stops until I minimize firefox (then BA again working fine)

In my other laptop with windows 7 I notice that BA still working when I am at firefox

Is it something that normal or do I need to adjust something at XP?

I have another similar problem when I want to autoreload the QuickPick List (Gary's example sheet)

I have 3 tabs of BA (even with the same Market open) connected at 1 workbook with 3 sheets accordingly but at the next day only the first & "active" sheet will refresh.

Any ideas / help about it ?

by **GaryRussell** » Mon Jan 25, 2010 9:09 am

It doesn't make any sense at all. I cannot imagine how Firefox can possibly interfere with BA. Any chance you can I see for myself using remote assistance?

What exact trigger are you using to refresh the quick pick list?

by **mak** » Mon Jan 25, 2010 10:16 am

Gary hi,
I don't have problem to see by yourself but I will be available at afternoon I am at office right now

The trigger to refresh the quick pick list is mainly -3.12 but I have tried without sucess at all -3.16 & -3.6 & -3.5 that's why in another thread I am asking if this kind of rutines could be in the standard BA interface

* Bear in mind that at 64.q version the Help menu doesn't show some already available triggers as -3.16

Thanks

by **GaryRussell** » Thu Jan 28, 2010 1:40 pm

Sorry for the late response. Are you using the trigger on each worksheet or just one of them? You need to use the trigger on each worksheet.

by **mak** » Thu Jan 28, 2010 1:54 pm

Just answered in another thread the following

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...

by **mak** » Fri Jan 29, 2010 5:31 am

mak wrote:Just answered in another thread the following

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 particular market is updated

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

* Also working fine with firefox...

Gary hi
today (second day that left BA to run automated) my workbooks haven't updated but yesterday with the same code they did.
Do you have any idea what I am missing?

by **GaryRussell** » Fri Jan 29, 2010 6:03 am

Can you send me a copy of the spreadsheet so I can check if it's anything obvious?

by **mak** » Fri Jan 29, 2010 6:19 am

Just sent it

by **GaryRussell** » Fri Jan 29, 2010 9:10 am

Your spreadsheet seems ok to me. Have I got the full picture? I ask because you said previously

I have 3 tabs of BA (even with the same Market open) connected at 1 workbook with 3 sheets accordingly but at the next day only the first & "active" sheet will refresh.

The example you sent only has one market. Is this the one that failed this morning or was it multiple tab pages linked to multiple worksheets? Did the first one update and not the rest?

It's important that I know this because my example was not designed to work with multiple sheets in the same workbook, but can be modified to do so.

by **GaryRussell** » Fri Jan 29, 2010 9:19 am

There is another possibility. Was Betting Assistant left running from the previous day and therefore it was linked to the last closed market from the previous day or had you restarted Betting Assistant and set up the link to Excel without selecting a market? If it wasn't initally linked to a market then my example will not work and will need modifying.

by **mak** » Fri Jan 29, 2010 10:48 am

Gary 5 posts earlier I have the following

"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)"

Also I confirm Betting Assistant was left running from the previous day and therefore it was linked to the last closed market from the previous day & it stayed there...

by **GaryRussell** » Fri Jan 29, 2010 10:52 am

Sorry, I somehow missed that even though I read it :oops:

Can you upgrade to version 1.1.0.64s and let me know if the problem still occurs. I made a change that should ensure it works even if an API error is encountered which may have happened although not very probable. If you are available for a remote support session please email me immediately and if I am around I will do remote support.

by **GaryRussell** » Fri Jan 29, 2010 10:54 am

Also if you email for remote support can you leave BA and Excel open so that I can examine the state of BA and the spreadsheet.

by **mak** » Fri Jan 29, 2010 11:05 am

email sent

by **GaryRussell** » Fri Jan 29, 2010 11:35 am

mak wrote:email sent

I have replied.

XP problem?

XP problem?

Who is online

Sports betting software from Gruss Software