locked
Save workbook with SaveCopyAs. RRS feed

  • 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

    Tuesday, January 11, 2011 1:35 AM

Answers

  • User-949037948 posted

    Hello,

       Try to use following code,

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



     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 11, 2011 2:29 AM

All replies

  • User-949037948 posted

    Hello,

       Try to use following code,

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



     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 11, 2011 2:29 AM
  • User1996548659 posted

    Dear Friend,

     

    Thnks a lot i solved my issue.

    Thnks.

    Tuesday, January 11, 2011 2:55 AM
  • User-2103114970 posted

    Thank you Very much

    jason tb  Great job

    Friday, June 29, 2012 12:06 PM