Save Excel file when using Excel Buffer

schwenthschwenth Member Posts: 11
Hello,

can someone tell me how it's posible to save a excel file after it has been created by using the excel buffer. ExcelBuffer.GiveUserControl is not possible because I want to create Excel files in a background job.

Regards,

Thilo

Comments

  • stebbijonsstebbijons Member Posts: 2
    I haven't tried this but you could add a function to the ExcelBuffer table to use instead of the GiveUserControl function.
    Function SaveWorkBook(MyFilePath : Text 250)
    XlWorkBook.SaveAs(MyFilePath);
    XlWorkBook.Close(FALSE);
    XlApplication.Quit;
    CLEAR(XlApplication);
    

    Hope this helps...

    Stebbi
Sign In or Register to comment.