I am sorry for the late reply... Got Stuck in my Project Work.

It is saving in XLS format...

but my new problem is I am having Office 2010 installed on my Server which is having (Office14) dll

C:\Program Files\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office14\Microsoft.Office.Interop.Excel.dll.

And my client has Office 2003 installed on his machine. Below is the code I am using to Save the file as 2003 Workbook format.

The generated XLS file gets Corrupted only for those user's who has Office 2003 installed, for other user's the generated file is not corrupted.

_book.SaveAs("New.XLS", Excel.XlFileFormat.xlExcel8 , Missing.Value, Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

I want to find a Solution so that my generated xls file is not corrupted and it should not be dependant on any Office version.

Please help!!

Thanks

Monisha.