Auto clearing status cells

[tausen]

What does "Point at this spreadsheet to function" mean??
I've created a spreadsheet, but I can't copy the "Clear status" sheet into mine.
And I can't even copy mine into this.
It gives me VB errors. But I don't make change to the original....

[Rastis]

Folks,

I've just had a crack at downloading this spreadsheet too. However, i got a message saying that it is corrupted and the VBA is deleted...

[Rastis]

I've got the spreadsheet working (IE, it clears the cells when I click the Start button) but it doesn't continue to clear every 10 seconds thereafter.

Is this what it is supposed to do? Am I getting something wrong?

Cheers

[Asalve01]

Hi,

How would I change this to only remove the status when not in-play, ie my system revolves around laying in-play.

[Wyndon]

I would like to clear the status cells just once - after I've matched bets at the prices I want. Does anyone know if it's possible to adapt this to run when the market is suspended or (preferably) when the market is so many seconds in play?

[Wyndon]

I think I've cracked it! Just waiting for racing to start. This repeated update facility is phenemonally useful.

[TheTub]

How did you crack it?

I would use practice mode to start with. Auto-clearing status cells can result in hundreds of bets being placed in a very short space of time if you are not careful.

[Wyndon]

I spoke to soon! All sorts of problems appeared on a live test. I'd hoped to embed my own sub-routine into the periodic update macro - but it failed dismally. However, I reproduced a Calculate worksheet that I found on another search of the forum, which did the trick of automatically clearing the status cells once the market has been suspended. Testing went OK yesterday evening.

[EyePeaSea]

How did you crack it?

I would use practice mode to start with. Auto-clearing status cells can result in hundreds of bets being placed in a very short space of time if you are not careful.

Whilst I'm still running a system in 'beta' mode (real money, but small stakes), I'm happy to deliberately not clear cells. BetAngel's refusal to let me stake twice if I don't clear the cells has saved me a few times

[alto]

Hi.

I've got the spreadsheet working (IE, it clears the cells when I click the Start button) but it doesn't continue to clear every 10 seconds thereafter.

Is this what it is supposed to do? Am I getting something wrong?

I'm having the same issue.
Anyone have come up with an solution?

Thanks

[bamthwok]

Hi,

Can someone please help and advise how to make this idea work for the Betangel multiple spreadsheet.

Any advise is highly appreciated.

Cheers,
bamthwok

[tony63]

Hello.

I downloaded the spreadsheet that auto clears the cells yesterday and was planning to trial it today.

I know you are aware of this but is has probably slipped your mind, I am one of, I suspect, many people that are not able to sit and watch the markets but HAVE to rely on automation.

As soon as I open an unrelated worksheet I get "subscript out of range". When I go into the debugger the problem is

Worksheets("Sheet2").Range("a4") = 1

I can muddle my way through visual basic but I don't know enough to correct it. It appears that the routine is applying to the whole of Excel rather that the specific workbook.

Thanks.

[tony63]

Sorry - Should have said. I'm working on the latest version of Excel.

[nigelk]

If you have 2 or more workbooks open vba gets a bit confused as to which workbook you are referring to.

It's likely that the code refers only to its own workbook, which hasn't got a sheet named "Sheet2".

You'll need to fully qualify each reference to each workbook.

If I have 1 workbook open, Twb and Owb will give the same result. If I have 2 workbooks open, and the 2nd is the ACTIVE (the one you are looking at), Owb will return a different name.

Code: Select all

Sub test()


Dim Twb As Workbook, Owb As Workbook

Set Twb = ThisWorkbook
Set Owb = ActiveWorkbook

MsgBox Owb.Name


End Sub

This can refer to either workbook, (but will fail if it can't find a sheet named sheet1.)

Code: Select all

Owb.Sheets("Sheet1").Range("A2") = "1"

This will always refer to the workbook in which the code resides.(Again will fail if no sheet named sheet1).

Code: Select all

Twb.Sheets("Sheet1").Range("A2") = "1"

[andrewcichello]

Hi Everyone,

The attached file works for me however I'd like to use this with multiple sheets. Does anyone have a worksheet clearing status cells on multiple sheets? Or a work around? I want to bet on many races per day and clear the status cells every 60 seconds.

Any help would be greatly appreciated.

Cheers,

Andrew