Suppress The Excel Warnings

Question

In Excel VBA I would use Application.DisplayAlerts = False

IN C# I have tried:

Excel.Application oXL;

Excel._Workbook oWB;

oXL.DisplayAlerts = false;

oXL.Parent.DisplayAlerts = false;

And neither of them suppress the warning "This file already exists...etc."

Vulpes · Answer

It may be that just before the macro runs the DisplayAlerts property is automatically set back to true for security reasons. You could test this by inserting a line at the beginning of the macro to print (to a MsgBox say) the current value of the property. If that turns out to be the case, there's probably nothing you can do from the C# side, though you could check the macro security settings.

richard smith · Answer

Yes, I disabled the Macro's via Excel VBA & they have been disabled. I was wanting a way to do it via C# if possible.

Vulpes · Answer

Rather than disable the alerts using C# code, I'd see if it will work if you disable them in the macro itself.

richard smith · Answer

Yes...the statements above are how my procedure begins...then down on into the code I actually call an Excel Macro that does the saving piece.

Vulpes · Answer

Are you sure that you're setting the DisplayAlerts property to false before calling the SaveAs method or whatever it is you're doing?

Suppress The Excel Warnings

Answers (5)