Exception (HRESULT: 0x800AC472) when using Excel.Worksheet.Select after calling Excel.Workbook.SaveAs

by

In my case, the exception was been thrown because my excel Interop tools was displaying a modal dialog (associated with a expired licence key – shame on me). If I closed the dialog (which was been displayed in the background) and then hit ‘continue’ in Visual Studio, the program was able to connect to the xlsx file and retrive data succesfully.

More Related Contents:

  1. How to convert a column number (e.g. 127) into an Excel column (e.g. AA)
  2. How to read data of an Excel file using C#?
  3. Reading excel file using OLEDB Data Provider
  4. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  5. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  6. Closing Excel Application Process in C# after Data Access
  7. unable to cast COM object of type ‘microsoft.Office.Interop.Excel.ApplicationClass’ to ‘microsoft.Office.Interop.Excel.Application'”
  8. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  9. What is the algorithm to convert an Excel Column Letter into its Number?
  10. How to use use late binding to get excel instance?
  11. Cell color changing in Excel using C#
  12. Export DataTable to Excel File
  13. Fastest function to generate Excel column letters in C#
  14. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  15. The quest for the Excel custom function tooltip
  16. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  17. How to make correct date format when writing data to Excel
  18. C# – How to copy a single Excel worksheet from one workbook to another?
  19. Importing Excel into a DataTable Quickly
  20. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  21. How to save workbook without showing save dialog with Excel interop?
  22. Accessing Excel Custom Document Properties programmatically
  23. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  24. Query excel sheet in c#
  25. Optimal way to Read an Excel file (.xls/.xlsx)
  26. Cell styles in OpenXML spreadsheet (SpreadsheetML)
  27. Excel CustomTaskPane with WebBrowser control – keyboard/focus issues
  28. How do I get an Excel range using row and column numbers in VSTO / C#?
  29. Printing Excel using Interop
  30. How to import all the Excel sheets to DataSet in C#

Leave a Comment