Gruss Forum • View topic

by **christine** » Tue May 11, 2010 5:19 pm

Having thought I was sorted (thanks to Osknows), I have encountered another problem! Sometimes the markets fail to load (even though I've set them up to come on 2 mins before the off). I get a mesage stating 'Market Loading - req's Pending'. But nothing happens until I reload the bot. Could anyone shed any light on what's happening here, as it doesn't happen all the time, just sporadically? Many thanks.

by **GaryRussell** » Tue May 11, 2010 5:25 pm

See http://gruss-software.co.uk/forum/viewtopic.php?t=4842

I haven't yet found a cause originating in Betting Assistant. You could try re-installing office as osknows did.

by **clinton** » Wed May 12, 2010 10:11 am

The problem happened to me too, and it is the second time... :-(

by **clinton** » Wed May 12, 2010 10:28 am

I sent you the log files as u requested in another thread

by **osknows** » Wed May 12, 2010 12:59 pm

I was having the same problem and also had a very strange issue where after a crash, excel would select a sperate cell to the one I clicked on.

I uninstalled excel completely from the control panel re-installed and everything seems okay so far...

by **Ian** » Wed May 12, 2010 1:34 pm

This has happened to me a number of times (I thought it was my crap VBA :lol:

). After a number of crashes close together, I could start Excel but not open any worksheet. Vista then directed me to the following fix

http://code.msdn.microsoft.com/KB972685

which I have downloaded and havn't had any problems since. Touch wood.

Don't know if it's related to your problem or not.

by **christine** » Wed May 12, 2010 9:49 pm

Thanks for the advice guys. It's been alright today, but I'll definitely follow the advice given if it happens again.

by **kiint** » Thu May 13, 2010 9:16 am

I've had this problem of the market load seeming to stick when I've had a problem with my VBA code and the application.enableevents has been left as false. As soon as it is set to true, the markets load normally.
Have you got some subroutine that is neglecting to reset it back to true before exiting?

by **christine** » Thu May 13, 2010 3:59 pm

Hmm, I sense a big problem now! When I'm on the laptop, regardless of whether I'm looking at the bot or my Excel spreadsheet, or just surfing other stuff, everything runs perfectly, which is great, as I don't have to remember to put the bets on. However, if I leave the laptop for a while & don't use it, I can almost guarantee that on my return, it will have frozen with the 'Market Loading, req's pending' message. This is obviously not good, as a major point of a bot is to place bets when you're not around! I wondered about removing Excel, but obviously need to track down the original disk first to reinstall it. The last message before this one totally confused me, so I can't follow the advice given unfortunately.

by **christine** » Thu May 13, 2010 4:03 pm

Just to add, when this problem has occurred I get a box with a Microsoft Visual Basic error message in the Excel spreadsheet, which says: Run-time error '9': Subscript out of range. When I click 'end' on the error message box, the Betting Assistant runs as normal. Does this mean anything to anyone?

by **GaryRussell** » Thu May 13, 2010 5:07 pm

There must be a bug in your VBA code. That particular error means it's trying to reference an array item that does not exist, eg. trying to access the 11th item if only 10 items in the array. While the error is displayed BA cannot update Excel which is why it is stuck at "Req's pending". It sounds bad, but should be quite easy to solve as it should be fairly obvious what is wrong with the code.

If you can post the code on the forum then I am sure someone can see what is wrong.

by **christine** » Thu May 13, 2010 5:53 pm

Sorry to sound really thick, but how do I find the code? Once I find it, I will be more than happy to post it!

by **osknows** » Thu May 13, 2010 9:17 pm

Gary,

I think Christine might be using this http://www.mediafire.com/?dntjmwdntin (correct me if I'm wrong Christine)

There isn't anything in the code using arrays? It wouldn't be something similar to a problem I was having with offset ranges, perhaps it's trying to offset off the range of the sheet and causing the error

Very strange?

by **christine** » Thu May 13, 2010 10:09 pm

Yes, Os is right, that is exactly the spreadsheet I'm using.

I'm encountering the problem on & off, though it has worked perfectly this evening!

by **GaryRussell** » Fri May 14, 2010 6:52 am

There's only one line of code that could throw that error.

ThisWorkbook.Sheets(Target.Worksheet.Name).Range("J2").Value = "U"

The subscript is Target.Worksheet.Name. I can't see how it could be out of range unless the worksheet didn't exist. You could trap the error with an "on error goto" statement, but I'd rather know what is causing it. I'll see if I can replicate the error.

New problem!

New problem!

Who is online

Sports betting software from Gruss Software