Excel Help Please

[Northern Wizard]

All, I am due to go on holiday soon and I want to keep my bot running whilst away. This will require me to load each days horse racing win markets in the morning.

Does anyone know how I can create an excel command to do this?

Thanks in anticipation.

[Roger]

See the Help file "Using Excel" section, last paragraph. You have to use VBA, because BA clears the Q2 cell as a response, so no formula can survive.

[Northern Wizard]

thanks, does anyone have the relevant VBA code to hand?

[Roger]

Well, not tested, but just something like this:

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
     Application.EnableEvents = False
     If Cells(2,3).Value = 0.45 Then
          Cells(2,17).Value = -3
      End If
      Application.EnableEvents = True
End Sub


This should refresh the market list at 10:48 am.

[Northern Wizard]

Roger, thank you. I have got this working. Much appreciated.

[Roger]

You're very welcome.