| Author |
Message
|
| Fiets |
 Posted: Wed Mar 07, 2012 10:38 am Post subject: Probs communication Excel <--> BA |
 |
|
Joined: 07 Mar 2012
Posts: 5
|
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? |
|
| Back to top |
|
 |
| neeeel |
| Posted: Wed Mar 07, 2012 1:02 pm Post subject: |
|
|
Joined: 27 Jun 2010
Posts: 53
|
| which version of gruss are you using? |
|
| Back to top |
|
|
| Fiets |
| Posted: Wed Mar 07, 2012 11:09 pm Post subject: user ver 1.1.0.66x82 |
|
|
Joined: 07 Mar 2012
Posts: 5
|
I'm using BA software user ver 1.1.0.66x82
and Excel 2010
cheers |
|
| Back to top |
|
|
| neeeel |
| Posted: Thu Mar 08, 2012 1:03 am Post subject: |
|
|
Joined: 27 Jun 2010
Posts: 53
|
| 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 |
|
| Back to top |
|
|
| Fiets |
| Posted: Thu Mar 08, 2012 8:39 am Post subject: error |
|
|
Joined: 07 Mar 2012
Posts: 5
|
Dim WithEvents ba As BettingAssistantCom.ComClass
------------------------------------------------------------------------------
Private Sub CommandButton4_Click()
result = ba.cancelAllBets
End Sub
-------------------------------------------------------------------------------
The 'result = ba.cancelAllBets' gets yellow |
|
| Back to top |
|
|
| neeeel |
| Posted: Thu Mar 08, 2012 1:03 pm Post subject: |
|
|
Joined: 27 Jun 2010
Posts: 53
|
| what is the exact error message you are getting |
|
| Back to top |
|
|
| Fiets |
| Posted: Fri Mar 30, 2012 3:28 pm Post subject: |
|
|
Joined: 07 Mar 2012
Posts: 5
|
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 |
|
| Back to top |
|
|
| MarkRussell |
| Posted: Fri Mar 30, 2012 5:05 pm Post subject: |
|
|
Site Admin
Joined: 20 Feb 2007
Posts: 755
Location: Birmingham
|
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 |
|
| Back to top |
|
|
| Fiets |
| Posted: Mon Apr 02, 2012 8:54 am Post subject: |
|
|
Joined: 07 Mar 2012
Posts: 5
|
@ MarkRussell
Tanks for your help, it is working great now
Fiets |
|
| Back to top |
|
|
|
|
