How to save an Excel Sheet without a confirmation

[Guest]

Hi,

Anybody knows how to close an Excel object and save the excel sheet but without the interruption (confirmation)

Thanks in advance

 

[Armin Zingler]

Anybody knows how to close an Excel object and save the excel sheet
but without the interruption (confirmation)?

The question is more related to the Excel automation model:
microsoft.public.excel.progrmaming


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

 

[Herfried K. Wagner [MVP]]

Anybody knows how to close an Excel object and save the excel sheet but without the interruption (confirmation)?

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