Excelbuffer usage, save the MS Excel sheet to a file

Frederik

Hi all,

I know how to use the Excel buffer in Navision, but I use it only with "GiveUserControl".
After that command I can not do anything with the Excel sheet any more, the user has control over the sheet.
I would like however to know if there is a way to let the Excelbuffer save the MS Excel sheet to a file instead of "GiveUserControl" or if there is another way to arrange that the sheet is saved.

Thanks in advance,

Frederik

kapamarou

You could add a function in table ExclBuffer through which you could use the WorkBook Automation function "Save()".
I guess you'll need to provide a filename to some property.

Frederik

Hi Kampamarou,

I think our user license does not permit me to make an extra function into "Excel Buffer".
Maybe I can, e.g. by copying the "Excel Buffer" table but I have never done this

Frederik

Marije_Brummel

If you cannot access C/AL in the current table then you also cannot access it when you save it to another number.

Contact a developer that can make this change for you.

David_Singleton

Or you can copy the code into a report, if you have report designer it allows you to write code.