Overwrite Yes/No

[barski]

How do I prevent the overwrite yes/no popup when saving output as Excel?

here's how I'm saving

 

xlBook.SaveAs(@"c:\" + fileName,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Excel.XlSaveAsAccessMode.xlNoChange,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);

[Robby]

I think that one of the args in the SaveAs() is to 'not prompt for save"

[barski]

I'm with you I figured it was one the args in the saveas however it is one the properties of the app

 

xlApp.DisplayAlerts = false

[Robby]

good, so does it work?

[barski]

Like a champ!