Skip to main content

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!


#Extra!
#MainframeAccess

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!


#Extra!
#MainframeAccess

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

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

Thanks for the reply. I noticed that the macro worked in my collegues computers. I reinstalled Office and Extra and still had the same error. Then I had the computer formatted and everything reinstalled, and the macro started working.

Thanks for the reply. I noticed that the macro worked in my collegues computers. I reinstalled Office and Extra and still had the same error. Then I had the computer formatted and everything reinstalled, and the macro started working.

guitadashi,

There must have been a component that was corrupted and the reimage corrected that issue.  Thank you for the update.

Jeff

 

Terms & ConditionsAccessibility statement