Excel Compatibility checker disable in CVI

[bharathiraj]

I am trying to close the excel sheet using "ExcelRpt_WorkbookClose (excelWorkbookHandle, 1);". while closing  i am geeting Excel Compactibilty checker window as shown below. I want to disable this checker window. How to disable this excel compactibility checker in CVI? i googled this and i found that it is possible to disable using VB script. The link is http://msdn.microsoft.com/en-us/library/office/gg132972.aspx . 

[RobertoBozzolo]

How are you saving your workbook? Apparently you are using an old file format including newer functions in your file.

Not sure about it, but you may try to explicitly specify one file format while calling ExcelRpt_WorkbookSave passing the appropriate constant in  'format' parameter (ExRConst_WorkbookNormal should apply to old-style '.xls' files; constants are defined in excelreport.h file but see this page and this one for reference: you'll see that enumerated constant for '.xlsx' files should be 51, which is not listed in the include file).

Other useful questions are: which OS are you developing on? And which Excel version is installed on the development machine?

[bharathiraj]

I am saving file using 'ExcelRpt_WorkbookSave (excelWorkbookHandle, path, ExRConst_WorkbookNormal);', i.e., '.xls' format. In my system i have windows xp OS and MS office 2010(excel 2010). I want to save the file in .xls format only. But while closing the excel file through API , i want to disable the Compactibilty checker.