Excel not updating data when running macro
Posted by Bet Angel - Technical Support on 28 May 2014 09:50 AM

If you use a looped macro within Excel and connect to Bet Angel you may find the live market data will no longer update whilst the macro is running.

This is due to Excel giving priority to the macro and suspending external data feeds whilst the macro is running.

The solution is to add the 'DoEvents' instruction inside your macro. This tells Excel to interuppt what it is doing and update the data.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako