06-21-2016 02:08 PM
I have an excel 2003 front end that calls a SAS Stored Process. Based on the output of the Stored Process, reports are pulled and data is formatted. Now if the stored process ends in error a pop up comes with error warning. Is it possible to trap the error returned from stored process in VBA? I want to check the return code from the stored process and do/notdo subsequent process based on the return code. Now how to capture the return code and stop the error popup coming along? Sorry but I cound not find this in the SAS AddIn documentation and google has very limited help on SAS AddIn!
Any suggestion will be helpful.