I am using Office.Interop.Excel.Application in which i have to save a file using saveas() but before saving it i have to disable the Excel's OverWrite prompt . I did tries Application.DisplayAlerts = false;
But it's not working , How to do this??? Pl Help ?
It doesn't matter if you open an existing workbook or create a new one. Either way you still need to call .SaveAs() which is going to give you the overwrite prompt unless you do something like the code I posted above.