VBA Code with Bet Angel

[Fidib665]

Hi,
I am trying to write a VBA script that extracts information from the Bet Angel Excel Sheet, processes it and based on it then makes trades. The issue is that once I start the Macro, it completely blocks the original Excel Sheet in that the data there is not updated anymore. How can I ensure that the update of the Bet Angel Spreadsheet has the highest prio and the Macro only second prio?
Many thanks for your answers, Fidibus

[TheTub]

Are you looping a VBA script?

If so, you will need to place 'DoEvents' in your script. This allows excel to update from external data feeds.

[Fidib665]

Many thanks for your answer. I figured to use
Wait = Timer
While Timer < Wait + 5
DoEvents
Wend
Also works.
Greetings, Fidibus