Excel Buffer Functions (Table 370)

MarkKeenerMarkKeener Member Posts: 17
edited 2015-08-28 in NAV Three Tier
Does anyone have a list of the functions that are available in the Excel Buffer table. I'm speaking of the functions associated with all of the Xl* globals. I'm specifically looking for a "Save As" function so that I can automate saving the file in a certain format.

Many thanks in advance!!

Comments

  • postsauravpostsaurav Member Posts: 708
    Hi MarkKeener,

    Are you looking for a function to save a excel file in NAV 2013 onwards. IF that is the case please refer here

    http://saurav-nav.blogspot.in/2014/01/nav-2013-nav-2013-r2-save-export-to.html

    Let me know if you have any doubts.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • MarkKeenerMarkKeener Member Posts: 17
    Thank you for the reply! You took an interesting approach to saving the file by using the FileManagement codeunit.

    Specifically what I am wanting to do is save the Excel file in a specified location (which I could do using your functionality) but in a specified format - such as "Excel 2007" or "Excel 2010" instead of the default format.

    I'm trying to find out if anyone has a list of the embedded functions that are included in the Microsoft .NET globals that are included in the Excel Buffer table. In the older versions, you could create your own C/AL functions by attaching to the (well documented) libraries that were included in the table. Is that still possible?

    Again, MANY thanks!!
  • kamalRawatkamalRawat Member Posts: 2
    Hi Saurav

    I am using mention code in nav 2016 I face error could not find file on path

    " WshShell.Start('C:\WINDOWS\system32\FTP.EXE '+Argument+'>'+
    SourceRoot + 'log\' + 'log_export_'+NextEntryNo+ '.txt');
Sign In or Register to comment.