February 15th, 2013, 1:09 pm
Hi,I don't know if it is the same case, but I've had a similar problem (so as some of my friends who use Reuters Eikon at work). The cause was the Eikon Excel Addin, it runs in the background occasionally changing active sheets etc. The longer the code the more likely it is that the Addin causes problems. This can also be caused by some other addins (Eikon is the one most aggresiveby my count) and the sollution might be the same.I fixed most of the issues by switching the addin off and working on named objects rather than active ones (instead of activesheet I'd use sheets(i) and so on).