Delete Excel sheet randomly fails

Question

I am trying to delete Excel sheet via C++ code but randomly it fails. Here is the code:

HRESULT hr = AutoWrap(DISPATCH_METHOD, NULL, pXlSheet, L"Delete", 0);

This function returns S_OK even delete sheet failed but the sheet isn't deleted from the workbook.

Note: The system gives error sound, if delete sheet failed.

what is the OS, sometimes there is a problem of level integrity. — Blood-HaZaRd, Nov 28 '18 at 10:03
how to suppress delete sheet warning? I suspect that is the cause of issue. — usmanharoon, Nov 28 '18 at 11:32

score 0 · Accepted Answer · answered Dec 12 '18 at 12:17

This error occurs because while deleting sheets sometimes warning prompt appears even deleting empty sheet.

To suppress warning prompt i used the below snippet and it works fine.

Code snippet:

VARIANT vBool;
vBool.vt=VT_BOOL;
vBool.boolVal=FALSE;

hr = AutoWrap(DISPATCH_PROPERTYPUT, NULL, _pXlApp, L"DisplayAlerts",1,vBool);

This method returns S_OK:)

1 Answers1