By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,492 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,492 IT Pros & Developers. It's quick & easy.

How to save an Excel Sheet without a confirmation

P: n/a
Hi,

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

Thanks in advance
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Li Pang" <an*******@discussions.microsoft.com> schrieb

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

Nov 20 '05 #2

P: n/a
* "=?Utf-8?B?TGkgUGFuZw==?=" <an*******@discussions.microsoft.com> scripsit:
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
///

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.