in reply to Deleting excel sheet using win32::ole

set the Win32::OLE warn level for debugging. Set the level to '3', which will croak when any error happens.
Win32::OLE->Option(Warn => 3);
And also check for last recorded OLE Errors using the following method.
Win32::OLE->LastError();