Turn BA feed off in excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
sealebet
Posts: 10
Joined: Mon Dec 05, 2016 2:43 am

Is there any way (via some sort of VBA) to turn off the Bet Angel feed via an excel instruction?

I have lots of macros that auto run (i.e. i can’t manually stop the feed) at set intervals but they run very slow when the sheets are being updated. Anyone come across this problem? Thanks.
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Are you sure it's the feed thats slowing you down and not the calculations being made as a result of the feed?
you could try sandwiching your code with


Application.Calculation = xlManual
Application.ScreenUpdating = FALSE

'your code

Application.Calculation = xlAutomatic
Application.ScreenUpdating = TRUE
sealebet
Posts: 10
Joined: Mon Dec 05, 2016 2:43 am

Thanks sa7med. Exactly what I need.
It's a bit of both. I have too much code and too many sheets. Computer grinding to a halt.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”