My Excel was recently upgraded to Office 365 ProPlus (I think the prior version was Excel 2010). All my macros that get data from Extra have stopped working (myExtra! Enterprise 7.11). The macro freezes and Excel reports "MS Excel is waiting for another application to complete OLE action". I reduced the code to the simplest code that fails:
Sub Main() Dim system As Object Dim sessions As Object Dim sess0 As Object Dim tela As Object Set system = CreateObject("Extra.system") Set sessions = system.sessions Set sess0 = sessions(1) Set tela = sess0.screen tela.waithostquiet (300) tela.waithostquiet (300) End Sub
The problem occurs when accessing Extra from Excel. Please help!