Microsoft.Office.Interop.Excel SaveAs error when clicking no or ca
I get an "error from Hresult" when attempting to SaveAs and clicking no or
cancel.
Here is the line...
workbookWrapper.ComObject.SaveAs(reportTypeFileNam e,
Microsoft.Office.Interop.Excel.XlFileFormat.xlWork bookNormal, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode. xlNoChange, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
It will bring up a message to overwrite a file, if the user selects "yes"
then it works fine. Selecting "no" or "cancel" brings up Exception from
HResult:0X800A03EC. Any ideas on what is happening?
|