Moderator: 2020vision
by mellenec » Sun Mar 04, 2007 5:06 pm
by GeorgeUK » Sun Mar 04, 2007 6:28 pm
by Ian » Sun Mar 04, 2007 9:20 pm
by mellenec » Mon Mar 05, 2007 2:30 pm
GeorgeUK wrote:Not totally sure i follow this, but here goes.
If BA is updating Workbook1 Sheet1
then the worksheet_change event should run on this sheet each time anything in this sheet gets changed.
The only time code won't run is when you have already "broken" the code from running, possibly a break point or debug error.
Have you use the term activesheet within the event so it is then looking at the wrong sheet if you open another sheet or
workbook?
by GeorgeUK » Mon Mar 05, 2007 3:30 pm
by Ian » Mon Mar 05, 2007 4:08 pm
by mellenec » Mon Mar 05, 2007 4:41 pm
Ian wrote:The activate statement wouldn't work because as soon as the event is triggered the focus would switch away from your other wookbook. I thnk George was asking whether you had an activate statement rather than to add one. You need to post some of the code so we cann look at it.
by Ian » Mon Mar 05, 2007 5:37 pm
by mellenec » Mon Mar 05, 2007 5:47 pm
Ian wrote:Get rid of the activate statement and try
Set F1 = Workbooks("CurrentTestLatest").Sheets("Feuil1") .....etc.
I prefer to use With
eg With Workbooks("CurrentTestLatest").Sheets("Feuil1")
If .Range("A1").Value <> raceName Then
etc etc
End With
by Ian » Mon Mar 05, 2007 7:30 pm
The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.
Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.
Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.
He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.
We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.