Hi,
I am using the below approach..
1) Handle macro error in macro file using Error Handling (On Error Goto ErrorHandler) and store the captured Error Details in the same macro excel worksheet (.xlsm) file in Cell ""A1"".
2) After Run Macro VBO code ...