Options

How to SaveAsExcel as Excel 2003

ssmukhissmukhi Member Posts: 10
Hello, I am using NAV 2016. Is there any way I can specify which Excel Version to save in using the SAVEASEXCEL function? This is because I need to save a report as Excel 2003 because that is what the client has. When I was using NAV 2013, it saved as Excel 2003 by default so there was no issue.

Answers

  • Options
    SuDSuD Member Posts: 102
    I think you should save the file with ".xlt" extension..
  • Options
    ssmukhissmukhi Member Posts: 10
    SuD wrote: »
    I think you should save the file with ".xlt" extension..

    Sorry that didn't help. My purpose is to save the file as XLS so it can be read by our Barcode Printer software which only reads Excel versions 2003 and below.

    In NAV 2013, we had no issue.
  • Options
    SuDSuD Member Posts: 102
    ssmukhi wrote: »
    SuD wrote: »
    I think you should save the file with ".xlt" extension..

    Sorry that didn't help. My purpose is to save the file as XLS so it can be read by our Barcode Printer software which only reads Excel versions 2003 and below.

    In NAV 2013, we had no issue.

    Then you Should check table 370 and CreateBook function,it may help u...
  • Options
    ssmukhissmukhi Member Posts: 10
    SuD wrote: »
    ssmukhi wrote: »
    SuD wrote: »
    I think you should save the file with ".xlt" extension..

    Sorry that didn't help. My purpose is to save the file as XLS so it can be read by our Barcode Printer software which only reads Excel versions 2003 and below.

    In NAV 2013, we had no issue.

    Then you Should check table 370 and CreateBook function,it may help u...

    Thanks. I'll try that.
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.