SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS AddIn 4.3 Excel 2003 - Error Return Code from Stored Process to VBA

Reply
Occasional Contributor
Posts: 10

SAS AddIn 4.3 Excel 2003 - Error Return Code from Stored Process to VBA

Hi,

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.

Thanks

Arindam

Post a Question
Discussion Stats
  • 0 replies
  • 188 views
  • 0 likes
  • 1 in conversation