.NET code: How to save an Excel Sheet without a confirmation

Home | Index | Dotnet4all Snippets | Submit resources

How to save an Excel Sheet without a confirmation (Friday, October 08, 2004)

Found the following interesting discussion in the Newsgroups:

How to save an Excel Sheet without a confirmation by:Anonymous
Hi, Anybody knows how to close an Excel object and save the excel sheet but without the interruption (confirmation)? Thanks in advance
	Reply: by:Armin Zingler
	The question is more related to the Excel automation model: microsoft.public.excel.progrmaming -- Armin
	Reply: by:hirf-spam-me-here@gmx.at (Herfried K. Wagner [MVP])
	\\With Application .DisplayAlerts = False ThisWorkbook.SaveAs("D:\file.xls") .DisplayAlerts = True End With /// -- Herfried K. Wagner [MVP] <URL:http://dotnet.mvps.org/>

0 Comments:

Post a Comment

Previous Posts
    - How to add Columns to a combobox?
    - Populating Structure Arrays
    - System.Net.Sockets
    - How to get a Flashing TreeView Control on Web Page...
    - Grouped Headers in a datagrid
    - How to add an attachment to an expression mailto
    - HTTPWebRequest - better server error handling
    - Windows Forms datagrid won't show more than 255 ro...
    - How to create an About Dialog
    - equivalent of a Session variable in Windows Forms?...

Archives
    - 10/03/2004 - 10/10/2004
    - 10/10/2004 - 10/17/2004
    - 10/17/2004 - 10/24/2004
    - 10/24/2004 - 10/31/2004
    - 10/31/2004 - 11/07/2004
    - 11/21/2004 - 11/28/2004
    - 11/28/2004 - 12/05/2004
    - 12/05/2004 - 12/12/2004
    - 12/12/2004 - 12/19/2004
    - 12/19/2004 - 12/26/2004
    - 12/26/2004 - 01/02/2005
    - 01/23/2005 - 01/30/2005
    - 01/01/2006 - 01/08/2006
    - 09/24/2006 - 10/01/2006

  » .NET Code Snippets
  » .NET Articles
  » VB.NET Articles
  » Submit your resource to DotNet4All