Retrieve data in vba while sub has not ended yet

viktor.moortgat

Dear,

I am currently trying to retrieve data from Thomson Reuters via the Eikon Data APIs in VBA Excel. The problem I have is that the data only is retrieved the moment the sub stops running. In my case, I should be able to get the data, process it for a certain stock and directly do the same several times, without the stopping of the program. Data retrieval for 1 stocks works just fine, it is only when a loop is used for this, that it does not work. Anybody who can help?

Zhenya Kovalyov

@f9a5b5fd-d648-46de-b6c4-745a67cac406 try using DoEvents in your loop.