Upgraded to office 365 Excel macro freezes OLE error

Hi,

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!

Parents
  • guitadashi,

    The code that you posted does work for me with Office 365 Excel and Extra 9.5 (current version.) You may have run into an incompatibility between Office 365 and a pretty old version of Extra.(circa 2003.)  Your best bet is to upgrade to a more recent version of the product.  You can contact support2@microfocus.com for help on getting upgraded or you can DM me for more information.

    Thanks,

    Jeff

Reply
  • guitadashi,

    The code that you posted does work for me with Office 365 Excel and Extra 9.5 (current version.) You may have run into an incompatibility between Office 365 and a pretty old version of Extra.(circa 2003.)  Your best bet is to upgrade to a more recent version of the product.  You can contact support2@microfocus.com for help on getting upgraded or you can DM me for more information.

    Thanks,

    Jeff

Children