9

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.

lee-m
  • 2,269
  • 17
  • 29
j4m4l
  • 328
  • 2
  • 10
  • 22

3 Answers3

15

Try ThisWorkBook.DoNotPromptForConvert = true

More info at DoNotPromptForConvert

InBetween
  • 32,319
  • 3
  • 50
  • 90
  • Unfortunately not working for me. It is still telling me about compatibility issues. – C4d May 10 '16 at 16:02
  • 6
    I found you had to explicitly set all of the following in order to get it work: `ExcelApp.DisplayAlerts = false` `workbook.CheckCompatibility = false` `workbook.DoNotPromptForConvert = true` – Jason Faulkner Aug 03 '16 at 18:33
1

Try instead workbook.CheckCompatibility = false;

Keith
  • 37
  • 1
0

I used the following in bold to make it skip the compatibility issue.

ActiveWorkbook.SaveAs Filename:= filepath or filename .xls" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

user8670255
  • 1