Excel 2007 Bet submit Problem

[TANGOACE]

Has any one experienced any problems with Excel not firing in a bet. Auto select, trigger ticked, enabled macros, time balanced all attended. The race switches in okay, just no submission.

[MarkRussell]

Hi,

Are you sure you have the correct trigger and stake and odds filled in the trigger columns for the selection?

Mark

[Michal]

I have been using excel 2007 to fire bets using vb.net program and I have no issues with the trigger mechanism.

I used a strictly VBA enabeled spreadsheet before that also with 2007 and ok there as well. I would think that if BA recognises the spreadsheet and updates it ok the only test you can do is try a manualy type in some odds and stake and then type in BACK in Col Q on that row if your bets go through then its the macro .......

Michal

[TANGOACE]

Thanks for the replies, much appreciated, I did try a manual entry and it did fire a bet so I guess that narrows things down. I have been trying to fire the bet using the spreadsheet from the Betting School but this has not worked. I have made sure that enable macros is switched on, however at least we know now where to look.

[Michal]

What you need now is to find out where your problem is the best way is to step through the macro.

Type 'stop' in the macro probably at the top just as the code enters the sub. From there you should get a yellow line across the line of code
and you can step through by pressing F8 this advances the code by 1 line and allows you to see what is happening.

You'll also need to load a race into the sheet that serves as your price log and then disengage BA and alter the values so that they represent a condition in which you wish to fire the bet. Then forllow the advice above untill you get to the part of the code that should fire the bet and see then why it isnt.

I am asumming that the problem is that the actual BACK code does not appear in the spread sheet if it does and then the bet doesnot go through you need to ask for more advice then.

Michal

[Michal]

Also check the spelling of your triggers if they are appearing but not firing BACK LAY CANCEL and so on all in capitals. I have on many occasions nearly collapsed from frustration only to find spelling was a problem rather then logic of the code. Also if you use variables to store your data and then use these to triger the bets make sure that they are spelled corectly.
For instance you collect a value in a cell like this

GoodPrice = Cells(6,"F").Value

and then fire a bet if your Good Price is at $5

If GoodPrica => 5 then Cells(6,"Q").Value = "BACK"

it will never happen because I mispelled the goodprice variable. Turn on option explicit which will force you to Dim every variable but then it will let you know that you have a new one when you mispell ..... lol

Michal

[tamrood2000]

I had a problem like this and found that enanableevents needed to be set to True. It can go false if you error whilst in the VBA editor.