long GetMacroStatus (_bstr_t pFileName, BSTR * pStatus );

VISUAL BASIC:

GetMacroStatus (ByVal pFileName As String, ByRef pStatus As String) As Long

Parameters:

• pFileName: The filename with complete path for which you want to retrieve the status of the macro.
• pStatus: Returns the status of the last run of the macro whether it was Complete or Failed.

Return Value:

Returns 1 if there is any kind of failure, or 0 if successful.