View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NeedsExcelAssistance NeedsExcelAssistance is offline
external usenet poster
 
Posts: 1
Default 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?