https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Excel-integration-VBA-gt-listeners-failure/m-p/274584#M1822 <P>Hello,</P> <P>&nbsp;</P> <P>I'm trying to execute SAS Stored Macros from the Excel with VBA. Have sometimes &nbsp;failures of the listeners and couldn't really anderstand when it happends and what is the source of the problem, but usually when the SAS server is slow and I have a message that 'OLE is waiting fo SAS answer' on the other hand sometimes even having this message everything goes fine.&nbsp;</P> <P>How could i control the listener health? The problem is that I set up a loop checking if the execution is finished and having no answer from SAS make the loop endless and I don't know what is going on, cause when I check SAS processes are competed and everything went fine just I didn't get the event. It is the same On _StepError and _SubmitComplete listeners.</P> Thu, 02 Jun 2016 09:42:36 GMT gabriel_k 2016-06-02T09:42:36Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Excel-integration-VBA-gt-listeners-failure/m-p/274584#M1822 <P>Hello,</P> <P>&nbsp;</P> <P>I'm trying to execute SAS Stored Macros from the Excel with VBA. Have sometimes &nbsp;failures of the listeners and couldn't really anderstand when it happends and what is the source of the problem, but usually when the SAS server is slow and I have a message that 'OLE is waiting fo SAS answer' on the other hand sometimes even having this message everything goes fine.&nbsp;</P> <P>How could i control the listener health? The problem is that I set up a loop checking if the execution is finished and having no answer from SAS make the loop endless and I don't know what is going on, cause when I check SAS processes are competed and everything went fine just I didn't get the event. It is the same On _StepError and _SubmitComplete listeners.</P> Thu, 02 Jun 2016 09:42:36 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Excel-integration-VBA-gt-listeners-failure/m-p/274584#M1822 gabriel_k 2016-06-02T09:42:36Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Excel-integration-VBA-gt-listeners-failure/m-p/276184#M1829 <P>Are you trying to call SAS via the VBA shell function or are you using the SAS Integrated Object Model (IOM)? I'd strongly recommend using IOM if you're using the shell function as I suspect the problem you're encountering may be due to startup time for the background SAS session that needs to be opened.</P> Thu, 09 Jun 2016 08:30:18 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Excel-integration-VBA-gt-listeners-failure/m-p/276184#M1829 ChrisBrooks 2016-06-09T08:30:18Z