How can VBA detect if the STP resulted in an error?

sustagens — Wed, 22 Apr 2020 03:26:21 GMT

Is there a way to catch SP errors in VBA?

This portion of the VBA code brings in the Stored Process. I thought adding "On Error GoTo ErrMsg" prior to inserting the STP would work.

Dim stp_run_all As SASStoredProcess 'Bring in "Run all" STP

'On Error GoTo ErrMsg
Set stp_run_all = sas.InsertStoredProcess("/Drive/TOOL/SP_Dly_DandL_Run_all_AMO", Runner.Sheets("Run").Range("L6"), , outputParams, inputStreams)

I need to be able to catch when the STP errors, and then perform some things when it does (message box saying there was an error, delete some sheets, delete the STP from the file).

Any help appreciated!

topic How can VBA detect if the STP resulted in an error? in Microsoft Integration with SAS

How can VBA detect if the STP resulted in an error?