Save file in Excel and Email on the fly - NAV 2016

rnjbng

I have a very simple processing only report that goes through the Sales Header table for Quotes only and adds User Id, Quote No. and Amount in excel per User ID. At the end of my loop I am calling CreateExcelBook. I just want to save this spreadsheet and send it out as a attachment to the user ID. Emailing is not a issue but my issue is how to save it as a excel file on the fly while the report is running.
I have seen post in this forum for old version of NAV but unfortunately those Excel buffer functions do not exist in NAV 2016 or have changed in NAV 2016.

Any help is highly appreciated.

Thanks
RJ.

logger

Hi @rnjbng ,
If you use Excel Buffer table, you can create your own method in it to save workbook using SaveAs method of Excel DotNet variable.

logger

Hi @rnjbng ,
If you use Excel Buffer table, you can create your own method in it to save workbook using SaveAs method of Excel DotNet variable.

rnjbng

Thank you logger for your suggestion, I created my own function and works perfect. Thanks for your valuable suggestion.

melsimmons68

What is the code you used to save the excel file?