version 66x18

[GaryRussell]

Actually I've got version 66W3- (the new beta) could that be the problem?

Yes, this version does not support the waitForResult parameter. You need version 1.1.0.66x18. Please install from the link below.
http://www.gruss-software.co.uk/Betting ... _Beta2.msi

[Spike]

Unfortunately 66x18 is giving me a new problem, it's quite a complex error message so I've emailed you a screen-shot.

Michael

[GaryRussell]

Unfortunately 66x18 is giving me a new problem, it's quite a complex error message so I've emailed you a screen-shot.

Michael

I have changed the way that it fires events to the client. It means it can only support one client. You will need to go back to the official version 1.1.0.65y until I can find a solution to allow multiple clients. You can install the official version from the link below. You will need to uninstall the Beta version first.
http://www.gruss-software.co.uk/Betting ... istant.msi

[Spike]

I'll have to look for a work -around and use 66x18 as the official release doesn't have waitForResult.

Thanks for your time Gary, I know you're meant to be on paternity leave and I'm really sorry to have disturbed you.

"betPlaced" looks brilliant by the way- very useful. I had been using the transaction log as a record of bets and putting "markers" into the bets using different stakes eg £20.03 but that was a bit of a bodge and it'll be great to have a proper solution once I've got that working. I was thinking of asking for something like that but I was definitely going to leave it for a while!
waitForResult is working out brilliantly for me too- in effect it's let me combine a whole bunch of bots into one which is much more efficient, it's made a massive difference and I'm really happy with it.

As ever I am hugely impressed by Gruss- surely the best company I deal with in any field. If Gruss made lager it would be a damn site better than Carlsberg, that's for sure.

[GaryRussell]

I'll have to look for a work -around and use 66x18 as the official release doesn't have waitForResult.

Thanks for your time Gary, I know you're meant to be on paternity leave and I'm really sorry to have disturbed you.

"betPlaced" looks brilliant by the way- very useful. I had been using the transaction log as a record of bets and putting "markers" into the bets using different stakes eg £20.03 but that was a bit of a bodge and it'll be great to have a proper solution once I've got that working. I was thinking of asking for something like that but I was definitely going to leave it for a while!
waitForResult is working out brilliantly for me too- in effect it's let me combine a whole bunch of bots into one which is much more efficient, it's made a massive difference and I'm really happy with it.

As ever I am hugely impressed by Gruss- surely the best company I deal with in any field. If Gruss made lager it would be a damn site better than Carlsberg, that's for sure.

If you want to do a workaround then as long as you only have one instance of BettingAssistantCom.ComClass
you should be ok. You could put this in a module and declare as public. You can then refer to it from all worksheets. They must all be in the same workbook though. If you get the error after making this change then it may be that it's already instantiated, just close and re-open the workbook.

[Spike]

Brilliant- I'll try it. Thanks again.

[mak]

just sent you email

Gary did you receive my mail
After a restart i can't log the particular bot not even manually
I will probably find a way but would like to know if you found something

[GaryRussell]

Yes, I did, but I've not had chance to have a proper look yet. Please bear with me.

[GaryRussell]

Also if you cannot log even manually can you send the diagnostic log for this also.

[GaryRussell]

It might be beneficial to wipe the settings files and re-enter your preferences. Run the following program and then re-enter your preferences.
http://www.gruss-software.co.uk/Betting ... ttings.exe

[mak]

after a restart i log it manually
i think that i will wait for some time if you come up with something and see

[Spike]

If you want to do a workaround then as long as you only have one instance of BettingAssistantCom.ComClass
you should be ok. You could put this in a module and declare as public. You can then refer to it from all worksheets. They must all be in the same workbook though. If you get the error after making this change then it may be that it's already instantiated, just close and re-open the workbook.

Thanks for this suggestion Gary but sadly I'm finding that it's a bit beyond my knowledge of VBA. The underlying structure of my COM sheets is cribbed from the Test_BA_Com sample sheet and I'm forced to admit that I don't really know how it works. If it's an easy job for someone with your Jedi skills (or any VBA maestro who might be reading) I'd really appreciate some guidance on how to amend the Test_BA_Com sample sheet so that it can connect to two tabs on separate work sheets.

[GaryRussell]

If you want to do a workaround then as long as you only have one instance of BettingAssistantCom.ComClass
you should be ok. You could put this in a module and declare as public. You can then refer to it from all worksheets. They must all be in the same workbook though. If you get the error after making this change then it may be that it's already instantiated, just close and re-open the workbook.

Thanks for this suggestion Gary but sadly I'm finding that it's a bit beyond my knowledge of VBA. The underlying structure of my COM sheets is cribbed from the Test_BA_Com sample sheet and I'm forced to admit that I don't really know how it works. If it's an easy job for someone with your Jedi skills (or any VBA maestro who might be reading) I'd really appreciate some guidance on how to amend the Test_BA_Com sample sheet so that it can connect to two tabs on separate work sheets.

OK. I will send you an example.

[Lewis]

Experiencing problems with this version today.

I am getting the 'market loading' problem where I have two tabs open and both connected to a single sheet in excel however I am also getting random dropouts in connection from the 2nd tab to excel.

I have the same race on both tabs and they write to a single sheet however after a few minutes the second tab no longer writes?

[GaryRussell]

Experiencing problems with this version today.

I am getting the 'market loading' problem where I have two tabs open and both connected to a single sheet in excel however I am also getting random dropouts in connection from the 2nd tab to excel.

I have the same race on both tabs and they write to a single sheet however after a few minutes the second tab no longer writes?

Please select the problem tab in BA and select "Display Excel link activity" then copy and paste the log on this thread.