Overwrite Yes/No

[barski]

How do I prevent the overwrite yes/no popup when saving output as Excel?
heres how Im 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]

Im 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!