Running Macros while Bet Trader running

[monkey]

I would like to run a macro to clear the bet ref and time matched every 5 minutes during a football match to enable multiple triggerred bets to be made.

How would this be done without freezing the Bet Trader program?

[Captain Sensible]

I haven't found any problems with macros freezing Betfair trader. I usually use the CLEAR trigger to clear the cells when bets have been matched or certain criteria met so it's kick off again - you could use a simple macro timer like the one below to clear every 5 mins

ALt F11 to open the editor and add the following to the workbook

Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:05:00"), "timer"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnTime dTime, "timer", , False
End Sub

Then add the following macro to the modules

Public dTime As Date
Sub timer()
dTime = Now + TimeValue("00:05:00")
Application.OnTime dTime, "timer"

Range("Q14:U46").Select <<< ------------or whatever range your bet refs are in
Selection.ClearContents
Range("A1").Select
End Sub

[monkey]

Many thanks, worked a treat.