ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Microsoft.Office.Interop.Excel SaveAs error when clicking no or ca (https://www.excelbanter.com/excel-programming/367212-microsoft-office-interop-excel-saveas-error-when-clicking-no-ca.html)

NeedsExcelAssistance

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?


All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com