Stopping Confirmation

[Atley]

Using VB.Net 2003 to create Excel spreadsheets using MS Excel 11.0 object
library:

When I run my app in my dev environment, I am never prompted for things
like deleting sheets or saving files, but when I release it (with reference
DLLs copied local set to true) I am prompted for all of these events...

Is there a way to turn this off? or at least auto answer them?

 

[Herfried K. Wagner [MVP]]

Using VB.Net 2003 to create Excel spreadsheets using MS Excel 11.0 object
library:

When I run my app in my dev environment, I am never prompted for things
like deleting sheets or saving files, but when I release it (with
reference
DLLs copied local set to true) I am prompted for all of these events...

Is there a way to turn this off? or at least auto answer them?

\\\
With Application
.DisplayAlerts = False
ThisWorkbook.SaveAs("D:\file.xls")
.DisplayAlerts = True
End With
///

 

[Steve Long]

You could try

Excel.Application.DisplayAlerts = False