Excelbuffer usage, save the MS Excel sheet to a file

Frederik
Frederik Member Posts: 8
edited 2010-01-30 in NAV/Navision Classic Client
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

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    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
    Frederik Member Posts: 8
    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
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Or you can copy the code into a report, if you have report designer it allows you to write code.
    David Singleton

Categories