Then Please try with the OnStopTest Event. This event is called when an testcomplete stops executing a test. This event is working fine for me.
Please create a script file say common and add the event
function GeneralEvents_OnStopTest(Sender)
{
Log["Message"]("Event is caught");
Log["SaveResultsAs"]("C:\Testlog.mht",2);
}
//USEUNIT Common [ add a reference to common script file in your orignal script]
The above event will be called when you execution is over.
Please see the above lines of code works for you.
Note: The above code is in C# script. You have to modify it to work it for Vb script.
regards,
Saurabh