Save Excel file when using Excel Buffer

schwenth

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

stebbijons

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