Save workbook with SaveCopyAs.

Question

User1996548659 posted

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

Answer 1

User-949037948 posted

Hello,

   Try to use following code,

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

 

Answer 2

User1996548659 posted

Dear Friend,

 

Thnks a lot i solved my issue.

Thnks.

Answer 3

User-2103114970 posted

Thank you Very much

jason tb  Great job