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.
Turn BA feed off in excel
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
you could try sandwiching your code with
Application.Calculation = xlManual
Application.ScreenUpdating = FALSE
'your code
Application.Calculation = xlAutomatic
Application.ScreenUpdating = TRUE