Probs communication Excel <--> BA

[Fiets]

Hello,

I'm a new user and I'm testing some excel features.

If I try to cancel my orders via excel with a test sheet from the internet I always get the same VBA Debug Error ("ba.cancelAllBets") cannot be found.

It looks like VBA doesn't understand the BettingAssistantCom.ComClass language.

I checked the References (VBA --> Tools --> References) and BettingAssistantCom is checked there.


Please can somebody help?

[neeeel]

which version of gruss are you using?

[Fiets]

I'm using BA software user ver 1.1.0.66x82

and Excel 2010

cheers

[neeeel]

ok, thought it might be because you were using a really old version of gruss. Can you tell us the exact error message that comes up, and the line of code where it is used

[Fiets]

Dim WithEvents ba As BettingAssistantCom.ComClass
------------------------------------------------------------------------------
Private Sub CommandButton4_Click()
result = ba.cancelAllBets
End Sub
-------------------------------------------------------------------------------


The 'result = ba.cancelAllBets' gets yellow

[neeeel]

what is the exact error message you are getting

[Fiets]

Sorry for the late reaction and miss communication.

My question is this.

is is possible to make an excel macro that will cancel all bets that are in the market (and of cource unmatched)

if so, how does that macro look like (VBA)

kind regards

[MarkRussell]

Hi,

If you get the Beta version there is a trigger that wil cancel all unmatched bets in the market:-
CANCEL-ALL-MARKET

You just need to ensure that there is something in the Bet Ref column on the row where you use the trigger.
It doesn't have to be a valid bet ref you could just DUMMY for example.

Regards,
Mark

[Fiets]

@ MarkRussell

Tanks for your help, it is working great now

Fiets