Save Excel file when using Excel Buffer

schwenth
schwenth
edited 2006-11-02 in NAV/Navision Classic Client
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

  • stebbijons
    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

Categories