how to disable compatibility check in excel while automating through c#

c# automation excel-2007
j4m4l picture j4m4l · Jan 16, 2012 · Viewed 17.4k times · Source

I am using Excel 2007 interop assembly to automate Excel through c#. Interop version is 12.0. When I try to save a file, it can be saved only in 2003 format, but thats fine with me, yet I am getting a popup saying compatibility issue. How can I disable this popup?

I have already tried workbook.CheckCompatibility = false and ExcelApp.DisplayAlerts = false so please tell if I am making other mistakes.

I have MS Office 2007 installed on my computer.

Thanks in advance.

Answer

InBetween picture InBetween · Jan 16, 2012

Try ThisWorkBook.DoNotPromptForConvert = true

More info at DoNotPromptForConvert

Related questions

Microsoft.Office.Core Reference Missing

Using the example provided in codeproject I am struggling to work out where I can find the reference to the library Microsoft.Office.Core. I am getting the error "The referenced component 'Microsoft.Office.Core' could not be found." I …

Read More
How to get the range of occupied cells in excel sheet

I use C# to automate an excel file. I was able to get the workbook and the sheets it contains. If for example I have in sheet1 two cols and 5 rows. I wanted o get the range for the occupied …

Read More
Disposing of Microsoft.Office.Interop.Word.Application

(Somewhat of a follow on from the post (which remains unanswered): https://stackoverflow.com/q/6197829/314661) Using the following code Application app = new Application(); _Document doc = app.Documents.Open("myDocPath.docx", false, false, false); doc.PrintOut(false); doc.Close(); I am …

Read More