Save workbook with SaveCopyAs. RSS

• • Reply
  

  hspatil

  Member

  97 Points

  153 Posts

  Save workbook with SaveCopyAs.

  Jan 11, 2011 05:35 AM|LINK

  Dear All,

  I am using following code for create an excel file. But by this code it is asking dialog box as"You want to save that changes". I want avoid that dialog box. I tried with comment the second line therefore also it is not working.

  So can anybody tell me how to solve this issue ?

  WorkBook.SaveCopyAs(path);

  oWorkBook.Close(null, null, null);

  
  

  Thanks and Regard's

  Harish Patil

  Excel to SQL Excel vs OleDbConnection .net 2.0 .net 3.0 compatible Excel ADODB ODBC Excel asp.net c# excel not showing Excel run vba event excel c# import Excel Reading excel ado.net SqlBulkCopy .net3.5 Excel tab Excel Export XML excel on my web page Excel sheet counting Column excel formatting excel to pdf .net 3.5 Excel and SQL Server .NET 2.0 3.5 .net 2.0 compatible excell addin Excel in ASP.NET

  • Moved by ignatandrei on Jan 11, 2011 05:36 AM
• • Reply
  

  jason tb

  Member

  138 Points

  29 Posts

  Re: Save workbook with SaveCopyAs.

  Jan 11, 2011 06:29 AM|LINK

  Hello,
  
     Try to use following code,
  
  

  WorkBook.Saved = true;
      WorkBook.SaveCopyAs(path);
      WorkBook.Close(null, null, null);

  
  
   

  Stuck with automation, my c# excel/vb.net excel solution
  • Marked as answer by Vince Xu - MSFT on Jan 19, 2011 12:34 AM
• • Reply
  

  hspatil

  Member

  97 Points

  153 Posts

  Re: Save workbook with SaveCopyAs.

  Jan 11, 2011 06:55 AM|LINK

  Dear Friend,

   

  Thnks a lot i solved my issue.

  Thnks.

• • Reply
  

  mkonanki

  Contributor

  2820 Points

  624 Posts

  Re: Save workbook with SaveCopyAs.

  Jun 29, 2012 04:06 PM|LINK

  Thank you Very much

  jason tb  Great job

  Konanki